Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Problems with Excel Adding
I can entered data in Excel and use the autosum feature and that works or I
can use the formula =sum(a1..a55) and that works. However, if I copy and paste numbers from another spreadsheet and tried those function either I get zero and the formula is correct. I can even put =sum() mark the columns instead of typing in the range and it will still give me zero. It seems to be a copy and paste problem? I have never came across this before. I also, have a program that will list a report and I push a button that sends it to Excel and same thing. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Problems with Excel Adding
I bet your cells are text. They may look like numbers, but they aren't.
You can easily check with the ISTEXT() function. If they're text: Copy an empty cell Select your "numbers" EditPaste Special, check Add Now they should be numbers. But if you import numbers from other applications, ther may be spaces (Use TRIM()) or other unprintable characters. Use CLEAN(). There may even be Non-Breaking-Spaces; use Find and Replace to replace CHAR(160) with nothing ("") -- Kind regards, Niek Otten Microsoft MVP - Excel "klafert" wrote in message ... I can entered data in Excel and use the autosum feature and that works or I can use the formula =sum(a1..a55) and that works. However, if I copy and paste numbers from another spreadsheet and tried those function either I get zero and the formula is correct. I can even put =sum() mark the columns instead of typing in the range and it will still give me zero. It seems to be a copy and paste problem? I have never came across this before. I also, have a program that will list a report and I push a button that sends it to Excel and same thing. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Problems with Excel Adding
I forgot to put that I tried to format to numbers and also currency. Didn't
change a thing!!! "Niek Otten" wrote: I bet your cells are text. They may look like numbers, but they aren't. You can easily check with the ISTEXT() function. If they're text: Copy an empty cell Select your "numbers" EditPaste Special, check Add Now they should be numbers. But if you import numbers from other applications, ther may be spaces (Use TRIM()) or other unprintable characters. Use CLEAN(). There may even be Non-Breaking-Spaces; use Find and Replace to replace CHAR(160) with nothing ("") -- Kind regards, Niek Otten Microsoft MVP - Excel "klafert" wrote in message ... I can entered data in Excel and use the autosum feature and that works or I can use the formula =sum(a1..a55) and that works. However, if I copy and paste numbers from another spreadsheet and tried those function either I get zero and the formula is correct. I can even put =sum() mark the columns instead of typing in the range and it will still give me zero. It seems to be a copy and paste problem? I have never came across this before. I also, have a program that will list a report and I push a button that sends it to Excel and same thing. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Problems with Excel Adding
Niek has presumably won his bet. If the contents of the cell are text,
formatting numbers and currency will have no effect. You need to change text to numbers, as Niek told you. When ISTEXT() is false and ISNUMBER() is true, then you can continue. -- David Biddulph klafert wrote: I forgot to put that I tried to format to numbers and also currency. Didn't change a thing!!! "Niek Otten" wrote: I bet your cells are text. They may look like numbers, but they aren't. You can easily check with the ISTEXT() function. If they're text: Copy an empty cell Select your "numbers" EditPaste Special, check Add Now they should be numbers. But if you import numbers from other applications, ther may be spaces (Use TRIM()) or other unprintable characters. Use CLEAN(). There may even be Non-Breaking-Spaces; use Find and Replace to replace CHAR(160) with nothing ("") -- Kind regards, Niek Otten Microsoft MVP - Excel "klafert" wrote in message ... I can entered data in Excel and use the autosum feature and that works or I can use the formula =sum(a1..a55) and that works. However, if I copy and paste numbers from another spreadsheet and tried those function either I get zero and the formula is correct. I can even put =sum() mark the columns instead of typing in the range and it will still give me zero. It seems to be a copy and paste problem? I have never came across this before. I also, have a program that will list a report and I push a button that sends it to Excel and same thing. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Problems with Excel Adding | Excel Discussion (Misc queries) | |||
Problems adding a column | Excel Worksheet Functions | |||
Problems with adding on spreadsheet | Excel Discussion (Misc queries) | |||
problems adding days to a date | New Users to Excel | |||
Problems adding formula together. Please Help! | Excel Worksheet Functions |