date format?

T

Treesy

I'm trying to format a cell to return a date format of 02/07 for February
2007. I can't find it in date or custom. Any ideas? I'd be happy with 2/07
or 02/07. Please help!

Thanks.
 
P

Pete_UK

Go to Format | Cells | Number (tab) | Custom and type the format in
the panel:

mm/yy

overwriting whatever is there.

Hope this helps.

Pete
 
T

Treesy

Wow, that was too easy! Thanks to both of you. I've never created a custom
format, I've always just used ones in the list. Thanks again!!
 
Top