I believe the format Excel uses comes from the internals of Windows and
cannot be changed.

--
Jim
"srinivasan" wrote in message
...
| Dear community friends,
| Whenever I type a date format (yy-mm) excel exhibits the month in small
| letters. (Jan-07)
| Is there any option to show the same in capital letters?
|