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