Date Format in Excel 2007
Posted on 2011-10-08
I am trying to use the "Custom" method for formatting a calender date in a cell. I would like the date to read as: MAR 14 (the capital letters for the month is what I am after).
In the custom option of the formatting cells area, I enter the following custom string: MMM DD, however the result is: Mar 14.
I have tried to use Copy and Replace Special (values only), and have also tried "Find & Replace" to find "Oct" and replace with "OCT", but nothing works.
Thanks for any help.