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 |
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 |
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. |
All times are GMT +1. The time now is 04:03 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com