Archiver > GENEALOGY-DNA > 2010-11 > 1289754794

From: Robert Stafford <>
Subject: Re: [DNA] New FTDNA Project Format
Date: Sun, 14 Nov 2010 11:13:14 -0600
References: <><B0A97FB027D64C6AB00E3AEF55659BDF@julief20dec08><000e01cb83fd$2b6e3b00$824ab100$><215A1197496C4648B69F2A2FED6FCE24@elizabethod><><>
In-Reply-To: <>

That is for the Excel spreadsheet. I should have put that second, so it
would not be confusing. To get the data right click, select all, right
click, copy. The data will be reformatted by the spreadsheet. Paste to the
Excel spreadsheet after changing the universal format to text Then a bug
will appear at the bottom to let you select the destination format.

The second method I mentioned in the second post seems to be easier, since
you do not have to convert the number back from text to numerical.

Bob Stafford

On Sun, Nov 14, 2010 at 11:01 AM, Al Aburto <> wrote:

> "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

This thread: