Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 5
Default 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   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 35,218
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Scientific notation in text cells miles Excel Discussion (Misc queries) 3 December 7th 06 11:59 PM
change scientific notation (exponential) back to text GEORGIA Excel Discussion (Misc queries) 1 April 6th 06 04:21 PM
Excel 2003 won't let me change Xlabels from scientific notation CVb Charts and Charting in Excel 1 December 30th 05 03:22 PM
Using scientific notation in TEXT() function boopathi Excel Worksheet Functions 1 October 10th 05 08:23 PM
scientific notation to display 1.8 x 10-5 in Excel feloniousmoney New Users to Excel 1 July 6th 05 10:31 PM


All times are GMT +1. The time now is 02:33 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"