Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 On Wed, 27 Jan 2010 11:26:14 -0800, Nilesh.Patel wrote: 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 |
#3
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
"Nilesh.Patel" wrote:
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. 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 ----- "Nilesh.Patel" wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
formula needed that rounds to 99 cents | Excel Worksheet Functions | |||
formula rounds differently in 2 spreadsheets | Excel Worksheet Functions | |||
I need a %age increase formula that rounds up to the nearest $10 | Excel Worksheet Functions | |||
Round function that rounds down if 5 | Excel Worksheet Functions | |||
How can set how a number rounds up in excel | Excel Worksheet Functions |