Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Scientific Notation - I want excel to read it as a text not a numb
When I download a file from the internet, it gets saved as a *.csv file.
When I open it in Excel, I am having a problem with one column. It is a reference column. For example a record might have the reference number "24143236335900011300295" It seems Excel is automatically assuming this is a number and it appears as 2.4143E22. How can I convert that to text? Formatting the cells to "text" doesnt seem to be working. I am then importing this file into an Access Database. Thanks |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Scientific Notation - I want excel to read it as a text not a numb
Rename the .csv file to .txt
Then open that file in excel (via File|Open) You'll see the text to columns wizard pop up. You can specify that this field is Text. Jim McC wrote: When I download a file from the internet, it gets saved as a *.csv file. When I open it in Excel, I am having a problem with one column. It is a reference column. For example a record might have the reference number "24143236335900011300295" It seems Excel is automatically assuming this is a number and it appears as 2.4143E22. How can I convert that to text? Formatting the cells to "text" doesnt seem to be working. I am then importing this file into an Access Database. Thanks -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Scientific notation in text cells | Excel Discussion (Misc queries) | |||
change scientific notation (exponential) back to text | Excel Discussion (Misc queries) | |||
Excel 2003 won't let me change Xlabels from scientific notation | Charts and Charting in Excel | |||
Using scientific notation in TEXT() function | Excel Worksheet Functions | |||
scientific notation to display 1.8 x 10-5 in Excel | New Users to Excel |