convert text-format number to number in excel 2000%3f

's Computer Specifications

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.

's Computer Specifications

Copy an empty cell.
Select your "numbers". Edit>Paste Special, check Add.

--
Kind regards,

Niek Otten

Microsoft MVP - Excel

"Larry" <(E-Mail Removed)> wrote in message
news:496F097A-59F1-402E-8AEF-(E-Mail Removed)...
> 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.

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
how excel 2000 convert the number to time format ( Example 130511.	=?Utf-8?B?d29uZw==?=	Microsoft Excel Misc	2	25th Nov 2004 01:21 PM
Convert text to number - Excel 2000	Irina	Microsoft Excel Misc	0	27th Sep 2004 04:17 PM
Convert text to number - Excel 2000	Irina	Microsoft Excel Misc	3	25th Sep 2004 02:30 PM
Convert number in text format to number	=?Utf-8?B?Q2hlcnls?=	Microsoft Excel Programming	2	25th May 2004 06:51 PM
Re: How to convert text to number format	Ken Wright	Microsoft Excel Discussion	0	12th Jan 2004 09:17 PM