| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Custom Date Format
I would like to create a format in a cell that allows the number I enter to
be converted into a date in this format "MM/DD/YYYY". However, I would like to be able to enter the numbers w/o having to use the "/" as a separator btw. the month and day and the day and year. For example, if I enter the April 29, 2009 as "042909" in a cell, I would like the cell format to convert that to "04/29/09" instead of "6/23/17" which is what it does now. Thank you in advance for your assistance. |
| 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 | |||
Threaded Mode
