I'd like to display slashes in date cell when blank.

**IT_Padawan** · 11-08-2018, 11:14 AM

Pretty simple question:

I want to have " / / " (without the quotes) in my cells UNTIL a date is entered, in which case, format as a date would normally 11/8/18 (US format)

Kind of like how you set it to Accounting and it shows the $ sign until something is entered?

**jeffreybrown** · 11-08-2018, 11:18 AM

Then just set the format of the cell to what format you desire and then pre-load the cell with / /

Why would that not work?

**IT_Padawan** · 11-08-2018, 11:20 AM

... I feel stupid now. Thanks. Sorry to bother you.

**jeffreybrown** · 11-08-2018, 11:21 AM

No worries. Happy you have your solution and you're welcome.

I'd like to display slashes in date cell when blank.

LinkBack

Thread Tools

Rate This Thread

Display

I'd like to display slashes in date cell when blank.

Re: I'd like to display slashes in date cell when blank.

Re: I'd like to display slashes in date cell when blank.

Re: I'd like to display slashes in date cell when blank.

Thread Information

Users Browsing this Thread

Similar Threads

DATEDIF formula gives error when one date is not given. I want display blank cell

How to display a blank when copying a date from another workbook if the target cell is bla

Need to display blank when a cell has 0 date value

Display 'Date' cell as blank instead of default year 1900

[SOLVED] 8 digit date no slashes

how to put date slashes in to a column of number

In Excel 2003, entering date without slashes, the date is incorre.

Bookmarks

Bookmarks

Posting Permissions