Converting Numbers
 

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?

Hi Richard

click in an unused cell (maybe on another worksheet) and choose copy
select your "numbers" and choose edit / paste special - ADD
hopefully this will solve the problem.

--
Cheers
JulieD
check out www.hcts.net.au/tipsandtricks.htm
....well i'm working on it anyway
"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?

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?

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?

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?

That is correct.

VALUE Function can be used.

Gord

On Thu, 14 Apr 2005 20:33:02 -0400, "David DeRolph"
wrote:

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?