Thread: Numbers
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Peo Sjoblom Peo Sjoblom is offline
external usenet poster
 
Posts: 3,268
Default Numbers

Excel has 15 numerical digit precision so you can either preformat the cell
as text or precede the entry with an apostrophe '


--

Regards,

Peo Sjoblom





"Hector" wrote in message
...
I'm trying to enter a 17 digit number on a cell and somehow it always
changes
the last 2 numbers into a ceros. I have tried to format the cell to
number
and general and it coutinues to do so. but only when I enter a large
number
ei: 43343302223640001 then the one will auto change to cero.

help please. frustrated.