LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 15
Default Converting text???

Got a small problem, not sure how to fix it.

If I have this in a cell 5E+94, and it is suppose to be this 5E094, how do I
fix that? The file came from notepad and I copy and pasted it into excel and
then did text to columns. Is there something else there I should have done?

--
Thomas
 
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
Converting numbers to text bobs Excel Discussion (Misc queries) 1 August 21st 06 11:49 PM
Converting numbers stored as dates to text in Excel David from Furdale Excel Discussion (Misc queries) 1 July 17th 06 06:34 PM
Converting Text String to Separate Numbers Cincy Excel Discussion (Misc queries) 1 June 7th 06 10:30 AM
converting concatenated text strings into formulas z.entropic Excel Worksheet Functions 0 June 5th 06 06:15 PM
converting text to numeric data babooz Excel Worksheet Functions 3 May 19th 06 08:14 AM


All times are GMT +1. The time now is 08:39 AM.

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

About Us

"It's about Microsoft Excel"