View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Nilesh.Patel Nilesh.Patel is offline
external usenet poster
 
Posts: 1
Default Rounds the large numeric value

Hi,

I am trying to open a csv file with large numeric value.
Ex: 10028200934100567, 10028200934100658, 10028200934100666

When the file is opened in Excel 2007, it applies scientific number format
automatically and rounds the last two digits. I can not get back the original
value.

How can I prevent Excel from doing this automatic formatting?

Thanks,
Nilesh