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.