Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How do you divide all values in the worksheet by 1000000
|
#2
|
|||
|
|||
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 ... |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I clear a worksheet of values, but leave formulas intact? | Excel Worksheet Functions | |||
Search/Match between 2 x separate Worksheets and populate result in third worksheet | Excel Discussion (Misc queries) | |||
Adding values from one worksheet to another | Excel Worksheet Functions | |||
Weekly Transaction Processing | Excel Worksheet Functions | |||
how to extract only values from an Excel worksheet? | Excel Worksheet Functions |