Convert text to number for a table

[haganator]

How can I convert a large table of numbers stored as text to actual numbers...without going one by one? I tried highlighting all cells in the table and formatting them from text to numbers, but this didn't work.

Thanks,
Jeff

 

[Jonmo1]

Copy any EMTPY cell
Highlight the range you want to convert
Right Click - Paste Special - Values - Add

Hope that helps.

 

[Jeffrey Smith]

You could use the VALUE() function next to each cell, copy it down, then paste the column of numbers as values over the top of the text counterparts.

 

[Jeffrey Smith]

@jonmo1: nice!

 

[haganator]

Thanks...it worked like a charm!

 

[Jonmo1]

Thanks...it worked like a charm!

Glad to help, thanks for the feedback.

@jonmo1: nice!

Thanks, that's why I get the big bucks
....NOT.

 

[Rick Rothstein]

Another method that should work... Select the column of text "numbers", format the cells as General (if they are not already formatted that way), press ALT+de to bring up the Convert Text To Columns dialog box and click the Finish button as soon as the dialog box appears.