Results 1 to 3 of 3
  1. #1
    Join Date
    Apr 2004
    Location
    metro Detroit
    Posts
    634

    Unanswered: xp formatting issue

    I recently upgraded from office 2k to xp. I have an xls file with links to another xls file. If the cell in the source file is empty the cell in the linked file is showing a 0 (or zero value) rather than a blank cell. This was not happening in 2k.

    Does anyone know why this is happening and how to prevent it? I'm trying to avoid going through all the formulas on several worksheets and adding an if statement to fix this.

  2. #2
    Join Date
    Mar 2004
    Location
    Fort Worth, Texas, USA
    Posts
    68
    Not the answer you were hoping for, but you can choose not to display zeroes with Tools, Options, View, Zero Values.

  3. #3
    Join Date
    Apr 2004
    Location
    metro Detroit
    Posts
    634
    Thanks

    That seems to do the trick. Now if only word had that option, I'm having the same problem with a mail merge doc. Gotta love theese 'upgrades'.

Posting Permissions

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