Excel question
Discussion
Writing up my accounts and have a snag.
I have copied my bank statements across from web page onto excel spreadsheet. Now that I want to try and do some sums with the columns they are all totalling 0.
If I retype a figure then the sum at the bottom goes up by that amount.
Short of retyping every figure in 9 months of bank statements how can I get excel to see the pasted text as numbers?
Tried converting all fields to 'number' but no success. Spent a bit of time on help but couldn't find anything useful.
TIA
I have copied my bank statements across from web page onto excel spreadsheet. Now that I want to try and do some sums with the columns they are all totalling 0.
If I retype a figure then the sum at the bottom goes up by that amount.
Short of retyping every figure in 9 months of bank statements how can I get excel to see the pasted text as numbers?
Tried converting all fields to 'number' but no success. Spent a bit of time on help but couldn't find anything useful.
TIA
Try this, should work.....
In an empty cell, enter the number 1.
Select the cell, and on the Edit menu, click Copy.
Select the range of numbers stored as text you want to convert.
On the Edit menu, click Paste Special.
Under Operation, click Multiply.
Click OK.
Delete the content of the cell entered in the first step.
cheers
nick
In an empty cell, enter the number 1.
Select the cell, and on the Edit menu, click Copy.
Select the range of numbers stored as text you want to convert.
On the Edit menu, click Paste Special.
Under Operation, click Multiply.
Click OK.
Delete the content of the cell entered in the first step.
cheers
nick
sounds to me like you have individual cells selected for your sum.
Try this. make 2 cells on a new sheet A1 ($0) and A2 ($0) then make a 3rd cell A4 (=sum(A1:A2)). when you put in the new information, you insert new cells (not paste) into excel (excell will automatically expand the range of your sum). to make this easier, you can use freeze panes and hide cells. you dont have to do it exactly like i did, but thats how i would do it. I would also format it as currency, not a number (i think it looks more neat).
Try this. make 2 cells on a new sheet A1 ($0) and A2 ($0) then make a 3rd cell A4 (=sum(A1:A2)). when you put in the new information, you insert new cells (not paste) into excel (excell will automatically expand the range of your sum). to make this easier, you can use freeze panes and hide cells. you dont have to do it exactly like i did, but thats how i would do it. I would also format it as currency, not a number (i think it looks more neat).
Edited by dblack1 on Sunday 2nd January 00:58
Nicholas Blair said:
Try this, should work.....
In an empty cell, enter the number 1.
Select the cell, and on the Edit menu, click Copy.
Select the range of numbers stored as text you want to convert.
On the Edit menu, click Paste Special.
Under Operation, click Multiply.
Click OK.
Delete the content of the cell entered in the first step.
cheers
nick
This will work - assuming that the post regarding being able to download your statement doesn't help.In an empty cell, enter the number 1.
Select the cell, and on the Edit menu, click Copy.
Select the range of numbers stored as text you want to convert.
On the Edit menu, click Paste Special.
Under Operation, click Multiply.
Click OK.
Delete the content of the cell entered in the first step.
cheers
nick
Gassing Station | Computers, Gadgets & Stuff | Top of Page | What's New | My Stuff