LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
TVC TVC is offline
external usenet poster
 
Posts: 5
Default Change text to numbers

I have a large spread sheet. I turned on the error checking and checked
numbers stored as text. I highlighted the numbers and clicked on the yellow
diamond with the exclamation point and clickee on text to number.
Afterwards, I get a message saying "not responding". I also used the cell
format command and clicked on number. This also did not work. Is there a
way to convert text to number that will not take so long?
 
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
Why won't my cells change from Text to % or Numbers Ezlpo Excel Discussion (Misc queries) 3 October 3rd 06 07:00 AM
How do I Change Numbers in text in MS-Excel Yaman Mahajan Excel Discussion (Misc queries) 2 May 7th 06 12:55 PM
the numbers are always in text and i cant seem to change them??? neil Excel Worksheet Functions 10 December 21st 05 08:41 PM
Change CSV-load cell format from GENERAL to TEXT for numbers? Morena Chris Matthews Excel Discussion (Misc queries) 1 October 14th 05 05:23 PM
change numbers to text thanks Excel Worksheet Functions 6 April 19th 05 12:47 AM


All times are GMT +1. The time now is 02:31 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"