Results 1 to 4 of 4
  1. #1
    WS Lounge VIP
    Join Date
    Mar 2002
    Location
    Newcazzle, UK
    Posts
    2,827
    Thanks
    136
    Thanked 482 Times in 459 Posts
    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

  2. #2
    Platinum Lounger
    Join Date
    Feb 2001
    Location
    Weert, Limburg, Netherlands
    Posts
    4,812
    Thanks
    0
    Thanked 0 Times in 0 Posts
    The only one I know of is using the ROUND worksheet function where needed.
    Jan Karel Pieterse
    Microsoft Excel MVP, WMVP
    www.jkp-ads.com
    Professional Office Developers Association

  3. #3
    WS Lounge VIP
    Join Date
    Mar 2002
    Location
    Newcazzle, UK
    Posts
    2,827
    Thanks
    136
    Thanked 482 Times in 459 Posts
    ..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

  4. #4
    5 Star Lounger
    Join Date
    Aug 2001
    Location
    Surrey, United Kingdom
    Posts
    1,001
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Hi Zeddy

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

    ROUND
    Cheers

    Steve

    Asking the questions everbody wants the answers too but feels too stupid to ask themselves :-)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •