Ask Your Question
0

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
2

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

Comments

Thank you!

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

Question Tools

1 follower

Stats

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

Seen: 20 times

Last updated: Dec 06