| 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! |
| 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) | |||
Threaded Mode
