Try this on a spare copy ..

Assume the prob lies with say, col B
where B1 contains a label,
with data in B2 down

Select the column B
Click Data Text to Columns
Click Finish
--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----
"gennario" wrote in message
...
I have a large spreadsheet with a column that has the numbers formatted as
text. I tried reformatting the column from numbers to text but when I sum
the
column with other columns (that are formatted as numbers) it still doesn't
show in the sum. The spreadsheet is too big for me to retype the numbers.
Can
anyone please help???