Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Numbers Wont Sum
This is strange. Occasionally when I paste numers from the web and say I
select 3 cells with numbers in them they wont total down in that Auto Sum area on the bottom right. Also a =SUM wont work for those cells. But if I retype over them then it all works fine. Any ideas? TIA Dennis ========= |
#2
|
|||
|
|||
Hi
They are text strings - not numbers. Set the cell format for range with imported data to General or to Numeric. Copy a number (NB! A number!) 1 (or 0) from elsewhere. Select the range with imported data, and then PasteSpecial.Multiply (PasteSpecial.Add) - press OK -- Arvi Laanemets (When sending e-mail, use address arvil<Attarkon.ee) "Dennis" wrote in message ... This is strange. Occasionally when I paste numers from the web and say I select 3 cells with numbers in them they wont total down in that Auto Sum area on the bottom right. Also a =SUM wont work for those cells. But if I retype over them then it all works fine. Any ideas? TIA Dennis ========= |
#3
|
|||
|
|||
This sounds as if they are being pasted as text, not numbers. When you type
them, they are then input as numbers. -- HTH RP (remove nothere from the email address if mailing direct) "Dennis" wrote in message ... This is strange. Occasionally when I paste numers from the web and say I select 3 cells with numbers in them they wont total down in that Auto Sum area on the bottom right. Also a =SUM wont work for those cells. But if I retype over them then it all works fine. Any ideas? TIA Dennis ========= |
#4
|
|||
|
|||
Dennis
It's always possible that spurious invisible data gets brought over. This stops Excel from seeing the data as a 'number' and can then do no calculation on it. You could try entering a 1 in a blank cell and copy it. Then highlight your imported data and EditPaste Special...Values+Multiply. Of course multiplying a number by one does nothing, but it will kick Excel into recognising them. -- HTH Nick Hodge Microsoft MVP - Excel Southampton, England HIS "Dennis" wrote in message ... This is strange. Occasionally when I paste numers from the web and say I select 3 cells with numbers in them they wont total down in that Auto Sum area on the bottom right. Also a =SUM wont work for those cells. But if I retype over them then it all works fine. Any ideas? TIA Dennis ========= |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Seed numbers for random number generation, uniform distribution | Excel Discussion (Misc queries) | |||
Font with Monospaced Numbers | Excel Discussion (Misc queries) | |||
Sorting when some numbers have a text suffix | Excel Discussion (Misc queries) | |||
Sorting imported "numbers" | Excel Discussion (Misc queries) | |||
Paste rows of numbers from Word into single Excel cell | Excel Discussion (Misc queries) |