![]() |
Problems with excel please help
I am new to excel and can't find an answer to my problem i'm sure its
easy. I have a cell/field with about 100 numbers in which i want to copy which ive done and then multply it by 100 and display the result automaticallyhow can this be done. |
If you just want to multiply cell A1 by 100 and put the result in B1, you
need the following equation in B1 =A1*100 "Paul Moseley" wrote: I am new to excel and can't find an answer to my problem i'm sure its easy. I have a cell/field with about 100 numbers in which i want to copy which ive done and then multply it by 100 and display the result automaticallyhow can this be done. |
"Paul Moseley" wrote in message om... I am new to excel and can't find an answer to my problem i'm sure its easy. I have a cell/field with about 100 numbers in which i want to copy which ive done and then multply it by 100 and display the result automaticallyhow can this be done. You can use Paste special to do this. Here's a description: http://www.j-walk.com/ss/excel/usertips/tip059.htm /Fredrik |
All times are GMT +1. The time now is 03:01 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com