How to mass convert numbers stored as text to number?

[Jyggalag]

Hi all,

I have a VERY LARGE sheet like this:

All the numbers are "text" for some reason??

I want them to be numbers, but I have to manually click each cell and press "Convert to Number"

How can I do this faster for an entire column from B2:B5000?

Thanks!

Jyggalag

 

[Legacy 143009]

Copy your range. Paste with Ctrl+Alt+V.
In the pop up window, select Values and Add operation. Click OK.

 

[Fluff]

Another option is Text to columns, delimited, next, clear all check-boxes, Finish

 

[Jyggalag]

T

Copy your range. Paste with Ctrl+Alt+V.
In the pop up window, select Values and Add operation. Click OK.

This worked! No idea what the "Add Operation" does, but it worked haha

I tried a normal CTRL ALT V paste as values before, but it didnt work

so thank you very much Flashbond!

 

[Jyggalag]

Another option is Text to columns, delimited, next, clear all check-boxes, Finish

This would probably also work, thank you Fluff!

 

[Legacy 143009]

Actually, it does what it says. Normally, it adds the copied number to the pasted cell value. Since you don't have an actual number in cells, it just converts the string to a number and overwrites again.

 

[RoryA]

I want them to be numbers, but I have to manually click each cell and press "Convert to Number"

You don't actually. Select all the cells (doesn't matter if some are already numbers), then use the Convert to Number option in the tag.