Hi,
This is probably a basic question. Sorry for that, but I can't find the
answer in the excel help file.
I would like to multiply every cell in my excel document by 100. I
don't want to create any new cells. How do I do this?
Thanks
Raoulenter a 100 in a cell and copy it. now highlight all the data and select
Editgt;Paste special...gt;Values and multiply...delete the original 100
--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
www.nickhodge.co.uk
HISgt; wrote in message oups.com...
gt; Hi,
gt;
gt; This is probably a basic question. Sorry for that, but I can't find the
gt; answer in the excel help file.
gt;
gt; I would like to multiply every cell in my excel document by 100. I
gt; don't want to create any new cells. How do I do this?
gt;
gt; Thanks
gt; Raoul
gt;
- Jun 04 Wed 2008 20:44
multiply all values in all cells by a factor
close
全站熱搜
留言列表
發表留言
留言列表

