date format?
Thanks for feeding back - glad you got it to work.
Pete
On Mar 1, 6:14 pm, Treesy wrote:
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!!
"Pete_UK" wrote:
Go to Format | Cells | Number (tab) | Custom and type the format in
the panel:
mm/yy
overwriting whatever is there.
Hope this helps.
Pete
On Mar 1, 4:56 pm, Treesy wrote:
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.- Hide quoted text -
- Show quoted text -
|