Excel2003: Precision as displayed

[zeddy]

The Tools>Options>Calculation tab provides a workbook option for precision as displayed.

I have a need for "precision as displayed" but only for a single worksheet within a multi-sheet workbook.

Are there any workarounds???


zeddy

[pieterse]

The only one I know of is using the ROUND worksheet function where needed.

[zeddy]

..so for the 4000 values on the sheet that I want to have a 'precision as displayed' I would need to keep a separate log for the cells to define the 'precision' , a copy of the sheet with values as they are, and then another sheet with Round functions to compute the 'precision value'

I suppose I could export the sheet to a separate Excel file, switch to that file, turn on workbook precision as displayed for that file, and then re-import the data sheet????


zeddy

[stevehocking]

Hi Zeddy

This page shows a way of using the ROUND function instead of the precision function suggested earlier

ROUND