View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Sheeloo Sheeloo is offline
external usenet poster
 
Posts: 793
Default Excel Maximum viewable numbers in a cell

See http://www.cpearson.com/excel/rounding.htm

Excel's precision is 15 digits...
If you want to use bigger numbers then you can store them as text...

"Tony" wrote:

A cell doesn't seem to show more than 16 numers it turns the last 3, in my
case, to zeros. ie 8944456845364785123 is shown as 8944456845364785000. Not
a big user of Excel, hense this, i assume a simple solution.


--
Regards

Tony.