Using Custom Date Format in cell

M

mbp

I want the option to format my dates either as "dd mmm yyyy" or "mmm yyyy"
because some of my dates don't have the day listed. However, I cannot set up
a format that will read the cell contents correctly. If I don't have a day,
it inserts "01" instead of leaving it blank. Help!

Thanks...
 
D

David Biddulph

If you want to put a particular format in a particular cell, you can do
that. If you want it always to display exactly what you put into it, format
the cells as text before you put the data in, or prefix the text with an
apostrophe.
 
Top