multiply all values in all cells by a factor
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 |
multiply all values in all cells by a factor
enter a 100 in a cell and copy it. now highlight all the data and select
EditPaste special...Values and multiply...delete the original 100 -- HTH Nick Hodge Microsoft MVP - Excel Southampton, England www.nickhodge.co.uk HIS wrote in message oups.com... 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 |
All times are GMT +1. The time now is 09:04 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com