ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Divide in Excel 2000 (https://www.excelbanter.com/excel-worksheet-functions/176615-divide-excel-2000-a.html)

Mike

Divide in Excel 2000
 
How do I replace the contents of a col of cells & div each by 60 ?
Thank You.

T. Valko

Divide in Excel 2000
 
Try this:

Enter 60 in an empty cell
Copy that cell: EditCopy
Select the range of cells that you want divided
Then, EidtPaste specialDivideOK
Delete the cell holding the 60

--
Biff
Microsoft Excel MVP


"Mike" wrote in message
...
How do I replace the contents of a col of cells & div each by 60 ?
Thank You.





All times are GMT +1. The time now is 09:23 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com