View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Matthew P. Matthew P. is offline
external usenet poster
 
Posts: 1
Default Scientific Notation Issues

I have a cell displaying 1.03E+15. It appears that Excel rounded the actual
number to the nearest ending zero. 1030604200755582, 1030604200755583,
1030604200755581 all now show up as 103060420075580. I am opening it as a
..csv

Any suggestions?