| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Problem with Date Formatting
I am importing a text file with dates in the format 3/1/05. I need the data
formatted as DD-MMM-YYYY. I can get this for all dates EXCEPT where the leading zero has been dropped off the day, such as 3/1/05. Can anyone suggest how to do this in Excel? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Date Math Problem | Excel Worksheet Functions | |||
| Conditional Formatting (Date vs Number) | Excel Discussion (Misc queries) | |||
| problem with formatting cell to date format | Excel Worksheet Functions | |||
| Problem with Date format from VBA code | Excel Discussion (Misc queries) | |||
| Date Formatting | Excel Discussion (Misc queries) | |||
Linear Mode
