Changing A Column Of Text numbers To True Numbers: How ?

  • Thread starter Thread starter Robert11
  • Start date Start date
R

Robert11

Hello,

Using Excel 2007

Have a column of numbers that I entered as Text.

Wish to change the entire column, now, to "Numbers," so that I can apply a
formula (SUM) to them.

Apparently, it won't let me, even though I select the column and go to
"Format Cells" and select Numbers.

Still comes up as a Text column.

How to I change them to real "numbers", please ?

Thanks,
Bob
 
Robert11 said:
Hello,

Using Excel 2007

Have a column of numbers that I entered as Text.

Wish to change the entire column, now, to "Numbers," so that I can apply a
formula (SUM) to them.

Apparently, it won't let me, even though I select the column and go to
"Format Cells" and select Numbers.

Still comes up as a Text column.

How to I change them to real "numbers", please ?

Thanks,
Bob
Click to expand...

i use a freebie program called ASAP Utilities.
Lots of other uses also.

http://www.asap-utilities.com/download-asap-utilities.php

gls858
 
Format the column as Number or General then copy an empty cell.

Select the column and Edit>Paste Special(in place)>Add>OK>Esc

This will coerce the text numbers into real numbers.


Gord Dibben MS Excel MVP
 
Back
Top