ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   How do you divide all values in the worksheet by 1000000 (https://www.excelbanter.com/excel-worksheet-functions/23434-how-do-you-divide-all-values-worksheet-1000000-a.html)

me

How do you divide all values in the worksheet by 1000000
 


Franz

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