| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
DD-MON-YYYY never D-MON-YYYY
I need to format a date column to show leading zeros in the DD part.
How do I do this? I want 07-JUL-2009 I do not want 7-JUL-2009 Thank you |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
DD-MON-YYYY never D-MON-YYYY
Assuming data are real dates,
select the col, then click: FormatCellsCustom Type: dd-mmm-yyyy Click OK aha? punch the YES below -- Max Singapore http://savefile.com/projects/236895 Downloads:27,000 Files:200 Subscribers:70 xdemechanik --- "okey" wrote: I need to format a date column to show leading zeros in the DD part. How do I do this? I want 07-JUL-2009 I do not want 7-JUL-2009 Thank you |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| change date format from dd/mm/yyyy to mm/yyyy | Excel Discussion (Misc queries) | |||
| Formula bar shows mm/dd/yyyy. To show dd/mm/yyyy. How? | Excel Discussion (Misc queries) | |||
| How do I convert a birthdate format from yyyy/mm/dd to mm/dd/yyyy | Excel Worksheet Functions | |||
| how do I change date from mm/dd/yyyy to dd:mm:yyyy format in Excel | New Users to Excel | |||
| change birthday display from mm/dd/yyyy to HIDE the yyyy? | Excel Worksheet Functions | |||
Linear Mode
