Rounds the large numeric value

  • Thread starter Thread starter Nilesh.Patel
  • Start date Start date
N

Nilesh.Patel

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
 
Change the CSV to TXT extension.

When you open the *.txt file in Excel the Text Import Wizard will display
so's you can designate the format as Text.


Gord Dibben MS Excel MVP
 
Nilesh.Patel said:
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.
Click to expand...

If those are truly numbers (i.e. you intend to do arithmetic or other
numerical operations with them), then Excel is doing the correct thing. If
the scientific notation bothers you, change the cell format from General to
Number.

However, if they are really IDs (e.g. credit card "numbers"), you need to
enter them as text.

Sadly, I don't believe this can done with CSV file per se. You can change
the file extension to ".txt" and use the Text Import wizard (Data > Import
External Data in Excel 2003) to input the data.

Be sure click on Next, not Finish, to get to one of the last menus and
change the Column Data Format to Text instead of General. Unfortunately,
that will input everything in the column as text. So you might need to do
some conversion (of actual numbers) afterwards.

----- original message -----
 
Back
Top