Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Larry
 
Posts: n/a
Default convert text-format number to number in excel 2000%3f

The number in the cells are formatted as text, how can I convert them back to
number quickly. There are around 5000 cells in Excel Spreadsheet of Version
2000.
I tried: Format, Cell, Number, F2, but the conversion is number by number
and it takes too long.
  #2   Report Post  
Niek Otten
 
Posts: n/a
Default

Copy an empty cell.
Select your "numbers". EditPaste Special, check Add.

--
Kind regards,

Niek Otten

Microsoft MVP - Excel

"Larry" wrote in message
...
The number in the cells are formatted as text, how can I convert them back
to
number quickly. There are around 5000 cells in Excel Spreadsheet of
Version
2000.
I tried: Format, Cell, Number, F2, but the conversion is number by number
and it takes too long.



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
Formulas dealing with text data Bagia Excel Worksheet Functions 6 June 20th 05 10:29 PM
Using Excel converts number to english text Lionel Lim (Malaysia) Excel Worksheet Functions 1 April 22nd 05 10:16 PM
Format number as text on import Ron Swinehart Excel Discussion (Misc queries) 3 March 4th 05 11:59 PM
Convert data of cells to any type: Number, Date&Time, Text Kevin Excel Discussion (Misc queries) 0 December 30th 04 07:55 AM
Does Excel 2000 have a 'datedif' function to calculate the number. Kaddy Excel Worksheet Functions 7 December 11th 04 09:53 PM


All times are GMT +1. The time now is 07:41 PM.

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"