Simpler:

1. Copy an empty cell.
2. Select the range of numbers to convert.
3. Paste Special - Operation - Add

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"Ken" wrote in message
...
Fort Worth ... (Good morning)

1: Place "1" in an empty cell
2: Select the cell & COPY
3: Select your range of numbers with the leading space
4: PASTE/SPECIAL Multiply
5: Your Range Now formatted Numbers (no leading space)
6: Your SUM Formula should work

Kha




"frustrated in Fort Worth" wrote:

I copy-pasted data from a database into an excel worksheet. When I use
the
sum function on a column of numbers, excel says the sum is zero. I
formatted
the cells to make sure it was number and not text. Still says zero sum.
The
numbers are aligned to the right, but are indented one space. If I
manually
delete that space then the number is recognized by excel. I can't figure
out
how to get rid of the space in every cell and I don't know why it is
there. I
am using excel 2003 and running xp. Also, I noticed the argument included
a
"0" in it. For example =sum ("23";0;"13") With 23 and 13 being the
numbers I
want to add and 0 being the space that I can't get rid of. The 0s are the
only thing excel sees in the cells and so the sum is always zero. Does
anybody know what is going on? And how to fix it?