Thread: Date Formatting
View Single Post
  #1  
Old May 27th, 2010, 10:27 PM posted to microsoft.public.excel.misc
Tommy
external usenet poster
 
Posts: 149
Default 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?