OK, and another method would be to use VALUE to convert, right?

"Gord Dibben" <gorddibbATshawDOTca wrote in message
...
David

Info only.....

If the numbers are text, simply re-formatting to number will not do the
trick.

They must be forced to numbers.

See Julie's post for a method.


Gord Dibben Excel MVP

On Thu, 14 Apr 2005 12:13:30 -0400, "David DeRolph"

wrote:

Clearly, the "numbers" are not in a number format; they are being
recognized
by Excel as text, not numbers. With a cell containing one of these
"numbers", hit F2 to get in to edit mode look carefully at the characters.
Any spaces or other characters before or after the numbers? If so,
they'll
have to be removed. If not, then this might be a matter of simply using
Format to change the format of these cells.

Hope that helps,
David

"Richard" wrote in message
...
I imported some numbers from another program into Excel, and although the
numbers look fine in Excel, I am unable to add the numbers in Excel.
When
I
do the "Sum" command, it returns "0".

Can someone help?