View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
 
Posts: n/a
Default Numbers turning to Zero's

See answer in public.misc and please don't multipost.

Andy.

"DaveG" wrote in message
...
Hello,
I am trying to place a large number (19 digits), into a cell, I do this,
but
when I leave the cell the last four digits turn to zero's. Why?

Can anyone help, please.

When i go into format cell's the General shows the number in the following
format (*.*****E+13), this dosen't look right either, is it?