Prev: eliminate duplicates on a sheet
Next: Weeknum function help
From: Ashish Mathur on 4 Apr 2010 22:56
Hi,

Try one of the following:

1. Find space and replace with blank; or
2. Select the dataset and go to Data > Text to columns > Finish

--
Regards,

Ashish Mathur
Microsoft Excel MVP

"Janet" <Janet(a)discussions.microsoft.com> wrote in message
news:ECFB4C8E-7C22-4ED1-A3B8-69109F2698A2(a)microsoft.com...
> I have copied a column of numbers to excel and now cannot apply any
> formulas
> because the numbers are text. How can I convert the text to numbers?
> Thanks.
> --
> Janet

First  |  Prev  | 
Pages: 1 2
Prev: eliminate duplicates on a sheet
Next: Weeknum function help