If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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
|
|||
|
|||
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? |
Thread Tools | |
Display Modes | |
|
|