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

How to add day to PWA 2016 date format? 0
Excel date formate doesn't change 0
Date Formats 4
Remove date format? 3
Date Formats 1
Convert Date to MMYY format 2
Formatting Dates from Text to Numbers 2
Convert dates stored as text 2

Top