![]() |
How do you divide all values in the worksheet by 1000000
|
1) write the vlue you want to divide by in a cell;
2) select that cell and then copy; 3) select the range you want divide and then select Edit, CopyPasteSpecial and clic ond option Divide; 4) clic OK. Hoping to be helpful Regards P.S.: It's not polite writing a post blank with a question just in the subject... :-) -- Franz ---------------------------------------------------------------------------------------- To reply translate from italian InVento (no capital letters) ---------------------------------------------------------------------------------------- "me" ha scritto nel messaggio ... |
All times are GMT +1. The time now is 10:53 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com