Problems with excel please help

  • Thread starter Thread starter Paul Moseley
  • Start date Start date
P

Paul Moseley

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 said:
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top