GENEALOGY-DNA-L Archives

Archiver > GENEALOGY-DNA > 2010-11 > 1289753632


From: Robert Stafford <>
Subject: Re: [DNA] New FTDNA Project Format
Date: Sun, 14 Nov 2010 10:53:52 -0600
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>


To convert the text numbers to back to regular numbers, you need to select a
range and a bug will appear with the option to convert back to numbers. This
gets rid of the green text indicator in each box. Be certain to change the
universal format back to general.

I found only two columns that were affected. Another way is to paste and set
to the destination format. Then change the affected columns to text. Click
on the corner and delete the data. Then re-paste and set to destination
formatting. When you do text to columns, select numbers.

Bob Stafford

On Sun, Nov 14, 2010 at 8:53 AM, Robert Stafford <>wrote:


This thread: