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
Raoul
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
Raoul
enter a 100 in a cell and copy it. now highlight all the data and select
Edit>Paste special...>Values and multiply...delete the original 100
--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
www.nickhodge.co.uk
[email protected]HIS
<[email protected]> wrote in message
news:[email protected]...
> 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
> Raoul
>
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks