How do I format the date to show mm/dd NOT m/dd?
 

I always want to see 2 characters for the mm (month) and 2 characters for the
dd (day). How do I format the cell to accomplish this? The only option I
see is 1 character (or 2 only if necessary) for the mm (month).

Thanks.
--
smags

In FormatCellsNumber select Custom and enter mm/dd in the Type box.

Ian

"smags" wrote in message
...
I always want to see 2 characters for the mm (month) and 2 characters for
the
dd (day). How do I format the cell to accomplish this? The only option I
see is 1 character (or 2 only if necessary) for the mm (month).

Thanks.
--
smags