| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Date Formatting
I receive data everyday with the dates in the following format - 1/12/2025
(dd/mm/year), however I'm trying to format it to the following format- 01-Dec-25. The option is available under formatting, but the majority of the dates in the column I select don't format properly. I can't figure why this happens... Can anyone offer a suggestion as to how to format so the entire column formats? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Date Formatting
Your dates look like dates, but they are text to Excel. You need to convert
them to dates. Text-to-columns is one simple way. Regards, Fred "Tommy" wrote in message ... I receive data everyday with the dates in the following format - 1/12/2025 (dd/mm/year), however I'm trying to format it to the following format- 01-Dec-25. The option is available under formatting, but the majority of the dates in the column I select don't format properly. I can't figure why this happens... Can anyone offer a suggestion as to how to format so the entire column formats? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| conditional formatting for cell date to equal today's date | Excel Worksheet Functions | |||
| date formatting | Excel Discussion (Misc queries) | |||
| Date Formatting (*) | Excel Discussion (Misc queries) | |||
| Date formatting help | Excel Discussion (Misc queries) | |||
| XML date formatting | Excel Worksheet Functions | |||
Linear Mode
