| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel converts string in CSV file as number
A file named test.csv has one line in it:
16E035 This is an accounting code used at our university. If I open that file, Excel shows 1.6*10^36 in cell A1. If I specify that the value is a string: "16E035" Excel still converts it to 1.6*10^36. How should this value be entered in the file so Excel leaves it as a character string? Thanks for your help. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| When I enter a date in Excel it converts to a 5-digit number. WHY? | Excel Discussion (Misc queries) | |||
| Excel converts 9-digit string to sci. not. when saved as csv | Excel Discussion (Misc queries) | |||
| Excel file from IE auto converts to PDF | Excel Discussion (Misc queries) | |||
| Excel converts formula to number | New Users to Excel | |||
| Using Excel converts number to english text | Excel Worksheet Functions | |||
Threaded Mode
