To perform arithmetic on numbers with up to 32,767 significant digits
in Excel, try xlPrecision:
http://precisioncalc.com
More functions coming soon...
Greg
Croc001 wrote:
Using excel 2000
recieving data from client with 16 numeral characters within cells
cells show an abreviated listing for the number (2.06E+15)
When editing the the number (wanting to change the last number by 1
digit)
i.e.
2059510000000000 - change to - 2059510000000001
this change will not be kept??