Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Converting numbers and number formatting to a CSV file ?
Is there a way to convert cells with numbers to a CSV file and keep the
formatting?? I have a file with a list of 50+ items that are over 12 digits each . . ..when I save it in as a CSV file it defaults to the Scientific Exponential Notation (Ex: 9.78E+12) and loses any Excel formatting. Is there any way to keep the number formating and save it as CSV? I tried saving it as text and then as CSV but that didn't work. Any ideas? Thanks so much for your help! |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Converting numbers and number formatting to a CSV file ?
If you save as .csv and look at the .csv file with Notepad, you will see no
conversion. If, however, you re-open the .csv file with Excel, Excel will convert to Exp. format. Just re-name the file .txt rather than .csv, Excel will then bring up the Wizard and you can specify the field as Text. -- Gary''s Student gsnu200712 "Cecilia" wrote: Is there a way to convert cells with numbers to a CSV file and keep the formatting?? I have a file with a list of 50+ items that are over 12 digits each . . .when I save it in as a CSV file it defaults to the Scientific Exponential Notation (Ex: 9.78E+12) and loses any Excel formatting. Is there any way to keep the number formating and save it as CSV? I tried saving it as text and then as CSV but that didn't work. Any ideas? Thanks so much for your help! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Converting Negative Number to Postive number | Excel Worksheet Functions | |||
Converting Excel file to text delimited file | Excel Discussion (Misc queries) | |||
Converting positive numbers to negative numbers | Excel Worksheet Functions | |||
converting number string to number with decimal | Excel Worksheet Functions | |||
Converting numbers formatted as text to numbers | Excel Discussion (Misc queries) |