Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Numbers
I copied a range of numbers into excel from the internet. When I try to
'Autosum' them they will not add. I also cannot format them e.g can't change them to a currency or change the number of decimal places of any number in a cell. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Numbers
You probably got the values in text format.
There are a few options; 1. Paste it first into a text editor like Notepad and then remove spaces etc. 2. You can also try entering 1 in any blank cell, Copy it and the select the range where you have already pasted the values, right click, choose Paste Special, click on Multiply and hit OK. Let me know if solves your problem. Otherwise paste a few rows here so that I can analyze further. "clivert" wrote: I copied a range of numbers into excel from the internet. When I try to 'Autosum' them they will not add. I also cannot format them e.g can't change them to a currency or change the number of decimal places of any number in a cell. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Numbers
hi
i suspect that you internet number were pasted into excel as text. common problem. try this. type a 1 in a cell off to the side. copy it. highlight your internet numbers and pastespecial multipy regards FSt1 "clivert" wrote: I copied a range of numbers into excel from the internet. When I try to 'Autosum' them they will not add. I also cannot format them e.g can't change them to a currency or change the number of decimal places of any number in a cell. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Numbers
It sounds as if your *numbers* are actually text. Try highlighting all you
*numbers* and then running this small Macro: Sub ChangeIt() For Each cell In Selection If cell.Value < "" Then cell.Value = _ --Application.Trim(Application.Substitute _ (cell.Value, Chr(160), "")) End If Next cell End Sub -- HTH Sandy In Perth, the ancient capital of Scotland and the crowning place of kings Replace @mailinator.com with @tiscali.co.uk "clivert" wrote in message ... I copied a range of numbers into excel from the internet. When I try to 'Autosum' them they will not add. I also cannot format them e.g can't change them to a currency or change the number of decimal places of any number in a cell. |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Numbers
That means that you've got text, not numbers.
There are probably spaces or other non-printing characters in the cells with your numbers. Try copying an empty cell, then celling your range of "numbers", and then using Edit/ Paste Special/ Add. If you are lucky, that wil change your text to real numbers. If not, you'll have to find out what spurious characters you've got in the cells with your numbers, and get rid of them. -- David Biddulph "clivert" wrote in message ... I copied a range of numbers into excel from the internet. When I try to 'Autosum' them they will not add. I also cannot format them e.g can't change them to a currency or change the number of decimal places of any number in a cell. |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Numbers
Your numbers are text.
Format all to General. Copy a blank cell then select your range of "numbers" and editpaste specialaddokesc. Gord Dibben MS Excel MVP On Thu, 21 Aug 2008 10:39:02 -0700, clivert wrote: I copied a range of numbers into excel from the internet. When I try to 'Autosum' them they will not add. I also cannot format them e.g can't change them to a currency or change the number of decimal places of any number in a cell. |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
Numbers
Thanks Sheelo.
Tried option 1. Pasted column of #s into notepad and they aligned to the very left. when I clicked on the RHS of the numbers the cursur was offset to the right by one push of the 'backspace' button. Hit backspace beside every number and pasted back in and it worked. Nice one. "Sheeloo" wrote: You probably got the values in text format. There are a few options; 1. Paste it first into a text editor like Notepad and then remove spaces etc. 2. You can also try entering 1 in any blank cell, Copy it and the select the range where you have already pasted the values, right click, choose Paste Special, click on Multiply and hit OK. Let me know if solves your problem. Otherwise paste a few rows here so that I can analyze further. "clivert" wrote: I copied a range of numbers into excel from the internet. When I try to 'Autosum' them they will not add. I also cannot format them e.g can't change them to a currency or change the number of decimal places of any number in a cell. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Decimal Numbers typed into Excel 2003 read as whole numbers | Excel Discussion (Misc queries) | |||
VLOOKUP should compare numbers stored as text to plain numbers. | Excel Worksheet Functions | |||
Help! How do you get excel to find the x(changes daily, marked in a cell from another formula) highest numbers in a group of numbers and sum them up? | Excel Worksheet Functions | |||
Help! How do you get excel to find the x(changes daily, marked in a cell from another formula) highest numbers in a group of numbers and sum them up? | Excel Worksheet Functions | |||
to find missing serial numbers in randomly generated numbers | Excel Worksheet Functions |