Results 1 to 2 of 2

Thread: Query

  1. #1
    Join Date
    Mar 2004
    Posts
    36

    Unanswered: Query

    Hi,

    I need to complete a statement for my customers, but have a problem with one of the fields. When the customer has made a withdrawal so that they then have a nil balance, 0.00 will not appear on the spreadsheet, it becomes blank instead. I really need to show 0.00 rather than a blank space.

    Can anyone help?

    Thanks
    Attached Files Attached Files

  2. #2
    Join Date
    Jan 2004
    Location
    Aberdeen, Scotland
    Posts
    1,067
    Hi you have conditional Formatting on i.e. if cell is 0 then set everything to white
    Just take this formatting off then your 0 values should appear

    Dave

Posting Permissions

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