Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do i save a 12 digit number in a .csv document in excell?
i am trying to create a .csv (comma delimited text file) spreadsheet. one of
the columns contains a 12 digit number. when i go to save it, however, excell keeps changing the 12 digit number to scientific formula. is there any way to save a 12 digit number in a .csv document? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do i save a 12 digit number in a .csv document in excell?
Save your file as .csv
Then re-open the file with Notepad and you will see the correct format. However, if you re-open the file with Excel, then Excel will change the format to scientific. It's not the saving that's the problem, it's the re-openning. If you want Excel to stop "helping" you, then preceed the number with a single quote (apostrophe). -- Gary''s Student "darin van houten" wrote: i am trying to create a .csv (comma delimited text file) spreadsheet. one of the columns contains a 12 digit number. when i go to save it, however, excell keeps changing the 12 digit number to scientific formula. is there any way to save a 12 digit number in a .csv document? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do i save a 12 digit number in a .csv document in excell?
Format the cells as Number vs General & Excel will display all 12 digits ---Gjc -- gjcase ------------------------------------------------------------------------ gjcase's Profile: http://www.excelforum.com/member.php...o&userid=26061 View this thread: http://www.excelforum.com/showthread...hreadid=526745 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Difficult for me, probably basic to you | Excel Worksheet Functions | |||
Saving excel document as a .csv and not lose formats? | Excel Discussion (Misc queries) | |||
'document not saved' for 'save' or 'save as' an EXCEL file | Excel Discussion (Misc queries) | |||
I need week number in excell from a date, first week must be mini. | Excel Discussion (Misc queries) | |||
When we enter a 16 digit number (credit card) the last digit chan. | Excel Discussion (Misc queries) |