Using the ROUND Function

[lkh050551]

In Excel 2007, is there a way to set a whole spreadsheet or a file with multiple tabs to use a specific ROUND function and not have to type it into each cell? This could be done in the older versions of Excel.

 

[Scott Huish]

There was and still is an Fixed Decimal place entry in Excel, but not a way to apply a formula to an entire spreadsheet, without VBA or the formula in the cells.

Is Fixed Decimals what you are talking about?

If this is what you are talking about, from the help file:

Enter numbers with a fixed decimal point
Click the Microsoft Office Button , and then click Excel Options.
Click Advanced, and then under Editing options, select the Automatically insert a decimal point check box.
In the Places box, enter a positive number for digits to the right of the decimal point or a negative number for digits to the left of the decimal point.
For example, if you enter 3 in the Places box and then type 2834 in a cell, the value will be 2.834. If you enter -3 in the Places box and then type 283, the value will be 283000.

On the worksheet, click a cell, and then enter the number that you want.
Note Data that you typed in cells before selecting the Fixed decimal option is not affected.

Tip To temporarily override the Fixed decimal option, type a decimal point when you enter the number.

 

[shg]

Are you talking about Precision as Displayed? It's under Excel Options > Advanced.