Formatting a date to equal zero

[jlkirk]

I have a column that has both dates and zeros. I have formatted the column to return dates in the format "Month, Day, Year". However, when a cell contains a zero, it returns the date "January 0, 1900". Is there any way to change this so that it returns a zero instead of "January 0, 1900"?
Thanks in advance.

 

[MrKowz]

Try the following custom number format:

mmmm d, yyyy;;0

 

[VoG]

Try this Custom format

mmmm, d, yyyy;;0

 

[jlkirk]

Thanks guys, works great!

 

[MrKowz]

Thanks guys, works great!

Glad it works. Thank you for the feedback.