Convert text numbers to numeric format

SteveE

New Member
Joined
Oct 28, 2003
Messages
15
Could anyone please advise the function which I can use to convert numbers stored as text to numeric format.
any help welcome
 

Excel Facts

What is the fastest way to copy a formula?
If A2:A50000 contain data. Enter a formula in B2. Select B2. Double-click the Fill Handle and Excel will shoot the formula down to B50000.

Seti

Well-known Member
Joined
May 19, 2002
Messages
2,916
Depending on the layout of the data, you could try the Data|Text to Columns menu option.
 

SteveE

New Member
Joined
Oct 28, 2003
Messages
15
Many thanks I think I have found the correct function VALUE this appears to work fine thanks for your help though.
 

FinancialAnalystKid

Well-known Member
Joined
Oct 14, 2004
Messages
779
OR... (I'm gonna use the menu upon right clicking with the MOUSE)

Select the range of cells you want to convert from TEXT to NUMBER.
Right Click on cells.
Choose Format Cells
Choose Number Tab
Click on NUMBER, and set decimal places.

OR... The more RELIABLE FORMAT CHANGE...

type a 1 in an empty cell.
Copy that cell with a [ctrl][c]
Select the range of cells you want to convert from TEXT to NUMBER.
Right Click selected range.
Select PASTE SPECIAL from menu.
Select MULTIPLY, click OK
then do what Seti suggested for good measure.
 

Forum statistics

Threads
1,147,622
Messages
5,742,199
Members
423,711
Latest member
luisfreitas

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