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.
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.
