Ask Your Question

How to differentiate date format? [closed]

asked 2018-12-06 11:01:32 +0100

Aigars gravatar image

I need to format a cell so that when I enter a date in format 6/12 it would show "december 6, 2018", but if I enter 0 it would show "____.____._______"

The first one is simple - just use a date format, but how to get it to show the other outcome when the date is "0"?

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by erAck
close date 2018-12-06 22:13:39.573265

1 Answer

Sort by » oldest newest most voted

answered 2018-12-06 11:10:48 +0100

Mike Kaganski gravatar image

updated 2018-12-06 11:11:30 +0100

[<>0]MMMM D, YYYY;"____.____._______"

See Number Format Codes.

edit flag offensive delete link more


Thank you!

Aigars gravatar imageAigars ( 2018-12-06 11:13:48 +0100 )edit

Question Tools

1 follower


Asked: 2018-12-06 11:01:32 +0100

Seen: 20 times

Last updated: Dec 06