Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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? |
#2
|
|||
|
|||
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? |
#3
|
|||
|
|||
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? |
#4
|
|||
|
|||
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? |
#5
|
|||
|
|||
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? |
#6
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Converting imported numbers to decimals (rather than /100) | Excel Worksheet Functions | |||
converting copied data to numbers in excel xp | New Users to Excel | |||
Converting Numbers to Text properly | Excel Discussion (Misc queries) | |||
roundoff when converting text to numbers | Excel Worksheet Functions | |||
Converting negative numbers in a range of cells to zero | Excel Discussion (Misc queries) |