ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Formating Worksheet Cells (https://www.excelbanter.com/excel-discussion-misc-queries/42283-formating-worksheet-cells.html)

Kjacob54

Formating Worksheet Cells
 
?
How do you format a worksheet to format all cells to round numbers to 2
decimal places. I am not talking about the cell format command that display
numbers. I am trying to have the speadsheet round all numbers. I know that
Round(Range("A1"), 2) will work on an indivdual cell. Can this be applied
to the enetire work sheet or range of cells?


All times are GMT +1. The time now is 07:25 AM.

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