Dates

M

Myrna Larson

If you need to later do arithmetic on these cells, or refer the to them in
formulas, you should probably be content with Excel's built-in formats.
Otherwise you could use something like

=UPPER(TEXT(A1,"mmm dd, yyyy"))

but be aware that the result is text, not a number and no longer a date.
 
Top