OT:Excel query
Kenneth Brody
kenbrody at bestweb.net
Fri Feb 25 12:04:49 PST 2005
Quoting Courtney <courtney at northshoreagency.com>:
> Ken
>
> I would appreciate you forwarding this to the group...still having email
> problems directly to the fp group...
Forwarding and answering at the same time...
> We have a 16-position field defined as *...it is all numerics, and we
> export it to excel, and it truncates the last two positions...
>
> Example 12492041890040466
>
> Comes out as 1.2492E+16...when I go in and make edit numeric with 0
> decimal:12492041890040400
>
> What are we doing wrong? How can we correct it?
You're doing nothing wrong. It's a limit in Excel. (Unless someone
here knows how to increase Excel's precision.)
To confirm this for yourself, start Excel with a blank sheet. Type
12492041890040466 into cell A1 and press Enter. Then move the cursor
back over that cell and you will see 12492041890040400.
--
KenBrody at BestWeb dot net spamtrap: <g8ymh8uf001 at sneakemail.com>
http://www.hvcomputer.com
http://www.fileProPlus.com
More information about the Filepro-list
mailing list