Results 1 to 3 of 3
  1. #1
    Mike Savides
    Guest

    Linked values don't always round correctly

    Once in a while, I notice that a linked value does not display (round) correctly. If I change the number of decimals (up or down) and then go back to the correct number, the value will correct itself. Also, some other actions (deleting certain rows, etc. have the same effect to correct the problem. (I'm using Excel 97 on Win 95, precision as displayed). How can I ensure that the values will always be correct? Calc Now (F9) doesn't help. Attached is an example. Thanks in advance for any help!

  2. #2
    Gold Lounger
    Join Date
    Feb 2001
    Location
    Dublin, Ireland, Republic of
    Posts
    2,697
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: Linked values don't always round correctly

    Mike, your attachment failed to attach.

    Perhaps you could try again

  3. #3
    Super Moderator WebGenii's Avatar
    Join Date
    Jan 2001
    Location
    Redcliff, Alberta, Canada
    Posts
    4,066
    Thanks
    2
    Thanked 5 Times in 5 Posts

    Re: Linked values don't always round correctly

    This thread is continued <A target="_blank" HREF=http://www.wopr.com/cgi-bin/w3t/showflat.pl?Cat=&Board=xl&Number=44595&page=0&view =expanded&sb=5>here</A>
    [b]Catharine Richardson (WebGenii)
    WebGenii Home Page
    Moderator: Spreadsheets, Other MS Apps, Presentation Apps, Visual Basic for Apps, Windows Mobile

Posting Permissions

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