Thread: Changing A Column Of Text numbers To True Numbers: How ?
View Single Post
  #2  
Old March 4th, 2009, 07:15 PM posted to microsoft.public.excel.newusers
gls858
external usenet poster
  
Posts: 473
Default Changing A Column Of Text numbers To True Numbers: How ?
Robert11 wrote:
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



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

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

gls858