Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
custom date format
I like to use this date format: 06-03-09 , but it isn't an option in my
Excel 2002 spreadsheet. I don't see it in FORMAT CELLS/DATE, or even in FORMAT CELLS/CUSTOM . Can someone show me if and how I can format an entire column to use this date format. jc |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
custom date format
hi
maybe it's not there.....yet. got to format cellsnumber tabcustom and enter this..... mm-dd-yy apply that to any column you wish. Regards FSt1 "jbclem" wrote: I like to use this date format: 06-03-09 , but it isn't an option in my Excel 2002 spreadsheet. I don't see it in FORMAT CELLS/DATE, or even in FORMAT CELLS/CUSTOM . Can someone show me if and how I can format an entire column to use this date format. jc |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
custom date format
jbclem wrote:
I like to use this date format: 06-03-09 , but it isn't an option in my Excel 2002 spreadsheet. I don't see it in FORMAT CELLS/DATE, or even in FORMAT CELLS/CUSTOM . Can someone show me if and how I can format an entire column to use this date format. jc Select the cells, Format | Cells | Custom and enter mm-dd-yy. You can specify pretty much any format you want here. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Need help with converting CUSTOM format/TEXT format to DATE format | Excel Worksheet Functions | |||
custom date format | Excel Discussion (Misc queries) | |||
Custom Date Format | Excel Discussion (Misc queries) | |||
Looking for custom date format | Excel Worksheet Functions | |||
Custom format date | New Users to Excel |