View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
charles charles is offline
external usenet poster
 
Posts: 124
Default MM/YY Formatting date Entry AND Display

I went into formatting for a cell and entered MM/YY.

When I enter i.e. "3/09" it displays 03/10 (meaning 3/9/2010). It appears
that if I enter any number between 1 & 31, it assumes it's the DAY. If I
enter 3/32, it works and displays 03/32 (meaning 3/01/2032).

So how do I format the number so that it knows the digits I enter are going
to be month then year. Is there a way to default it to always know the day
will be 01?