Results 1 to 5 of 5

hide cell values until you input information?

Threaded View

  1. #1
    Registered User
    Join Date
    04-05-2007
    Posts
    3

    hide cell values until you input information?

    Hey guys and girls. Is there a way to hide values in a cell until data has been inputted?

    For example, I have a cell with a formula that shows 00:00.70 until data is typed into corresponding cells. I don't want weird numbers like 00:00.70 to show with 0 values because they are distracting. Another cell shows #########.

    I never had this problem before because my formulas usually start off with 0 as the answer. Then I simply go to options and uncheck "show zero values."

    I'm stumped

    I have included a .pdf file to show you what I mean
    Attached Files Attached Files
    Last edited by h2o_polo_boi; 04-05-2007 at 08:45 PM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1