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
 

Excel Facts

Select a hidden cell
Somehide hide payroll data in column G? Press F5. Type G1. Enter. Look in formula bar while you arrow down through G.
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
 
Upvote 0
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.
 
Upvote 0

Forum statistics

Threads
1,218,518
Messages
6,142,927
Members
450,455
Latest member
Handienak

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
Back
Top