1) What does the date morph into?


2) Take a look at David McRitchie's macros:


http://www.mvps.org/dmcritchie/excel/proper.htm#lower

In article ,
date formats morph the dates/chang case <date formats morph the
dates/chang wrote:

Please, I'm just getting farther from the answer and I have to be up for
church soon. First question. I'm obtuse but when I type in a date, eg jan 1
05 and then format/cell/date I select a date format and it morphs in to a
completely different date.

2nd question: to change case, use UPPER or LOWER function. But, how does
that work to use the cell itself or a group of cells.