Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
date format?
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
date format?
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. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
date format?
Custom:
Enter mm/yy in the input box. In article , 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. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
date format?
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. |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 - |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Concatenating a Text and a Date without losing orginal Date Format | Excel Discussion (Misc queries) | |||
Can I change a date with no format (20051111) to date format? | New Users to Excel | |||
day/month/year in incorrect format for date format | Excel Worksheet Functions | |||
How can I convert a date format to an ISO week format (in EXCEL)? | Excel Discussion (Misc queries) | |||
Excel 2000 date format cannot be set to Australian date format | Excel Discussion (Misc queries) |