Date Formatting

T

Tommy

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?
 
F

Fred Smith

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Formatting Text to Numbers for Dates 2
date 1
Date Formats 1
date format 1
Convert dates stored as text 2
Formatting Text to Numbers for Dates 1
Formatting Date for Sorting 2
Date Format Not Responding to MM/DD/YY 2

Top