Numbers that start as text until I F2 then turns into a numb

jkchild

Board Regular
Joined
May 24, 2006
Messages
167
Hi I have some downloaded data the numbers are in one column but appear on the left hand side of the cell as if it were text.

If I F2 on a cell and press enter, it turns it into a number.

How can I get them to all turn to numbers quick, without editing each cell?
Thanks
I am using Excel 2000
 

Some videos you may like

Excel Facts

Copy PDF to Excel
Select data in PDF. Paste to Microsoft Word. Copy from Word and paste to Excel.

pgc01

MrExcel MVP
Joined
Apr 25, 2006
Messages
19,884
Hi jkchild

Write the number 0 in a cell

Edit>Copy

Select the range with the numbers as text

Edit>Paste Special>Add

Hope this is what you want
PGC
 

Yogi Anand

MrExcel MVP
Joined
Mar 12, 2002
Messages
11,454
Re: Numbers that start as text until I F2 then turns into a

Hi I have some downloaded data the numbers are in one column but appear on the left hand side of the cell as if it were text.

If I F2 on a cell and press enter, it turns it into a number.

How can I get them to all turn to numbers quick, without editing each cell?
Thanks
I am using Excel 2000

Hi jkchild:

Select all the entries ... and do DATA|Text_to_columns ... then ENTER

all the numbers that were text tntries woulbd become true numbers.
 

Watch MrExcel Video

Forum statistics

Threads
1,123,477
Messages
5,601,893
Members
414,479
Latest member
Beau the dog

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top