GENEALOGY-DNA-L Archives

Archiver > GENEALOGY-DNA > 2010-11 > 1289754048


From: Al Aburto <>
Subject: Re: [DNA] New FTDNA Project Format
Date: Sun, 14 Nov 2010 09:01:35 -0800
References: <BFECJOAEEPCFBFFLLBGPGEFJHJAA.dna@irishtype3dna.org> <B0A97FB027D64C6AB00E3AEF55659BDF@julief20dec08> <000e01cb83fd$2b6e3b00$824ab100$@dgmweb.net> <215A1197496C4648B69F2A2FED6FCE24@elizabethod><AANLkTim6kuQkpcO88jv7K71eHx6+7O_EWj_f7NGHeG=w@mail.gmail.com>
In-Reply-To: <AANLkTim6kuQkpcO88jv7K71eHx6+7O_EWj_f7NGHeG=w@mail.gmail.com>


"Click on left hand corner of spreadsheet and change universal cell
format to text."
This doesn't work for me on the public pages. I'm using Firefox. Are
you using something else or special plug-ins?
Al

> On 11/14/2010 6:53 AM, Robert Stafford wrote:
> It is just a little more trouble to convert to Excel. I did it from the
> public pages. Click on the left corner of the spreadsheet and change
> universal cell format to text. Select all and copy FTDNA table. Paste to
> spreadsheet. Select destination formatting from the bug at the bottom.
> Delete extraneous matter. Insert the extra columns needed next to the
> multicopy markers. From data, select text to columns with "-" as delimiter.
> Change universal format back to general.
>
> When adding data to a spreadsheet, you simply reformat the data on a new
> spreadsheet first, but often it is easier to copy results already on the
> spreadsheet and correct a few markers.
>
> Bob Stafford


This thread: