Formatting Numbers Using Precision as Displayed

To permanently change all values stored on a worksheet to their displayed values, use the Precision As Displayed option. Once this command has been invoked, you can t restore the original values. 

To change only a selected range of values to precision as displayed , use the FIXED worksheet function (see Text Fimctions in Chapter 3). 

Excel Tip. You can apply the same formatting to multiple worksheets simply by grouping the sheets (click on the first sheet tab in the range of sheets to be formatted, then hold down the SHIFT key and click on the last sheet in the range). When you apply the desired formatting to the active sheet it will be applied to all sheets in the group. 

---