| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
How do I format the date to show mm/dd NOT m/dd?
I always want to see 2 characters for the mm (month) and 2 characters for the
dd (day). How do I format the cell to accomplish this? The only option I see is 1 character (or 2 only if necessary) for the mm (month). Thanks. -- smags |
|
#2
|
|||
|
|||
|
In FormatCellsNumber select Custom and enter mm/dd in the Type box.
Ian "smags" wrote in message ... I always want to see 2 characters for the mm (month) and 2 characters for the dd (day). How do I format the cell to accomplish this? The only option I see is 1 character (or 2 only if necessary) for the mm (month). Thanks. -- smags |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel Date Format - Stop? | Excel Worksheet Functions | |||
| How do I format column containing date and time to only show the . | Excel Discussion (Misc queries) | |||
| USING THE DATE FORMAT IN EXCEL | Excel Discussion (Misc queries) | |||
| Problem with Date format from VBA code | Excel Discussion (Misc queries) | |||
| Show a date based on today | Excel Worksheet Functions | |||
Linear Mode
