date format using dot / period

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a user that did a custom format for a column to be mm.dd.yyyy. When I
type the date using slashes - Excel recognizes the data as a date. However,
my user typed the data using dots. I told her to find and replace the dots
and make them slashes to make the information correctly sort. But I am
curious, is there a way for excel to recognize numbers seperated with a dot
as a date opposed to an integer or decimal number? thank you
 
Only be either changing the windows settings for date delimiters (not
recommended) or using a macro
that will change the dots to date delimiters like / when you press enter or
you can temporarily change a dot to / in autocorrect


--

Regards,

Peo Sjoblom

http://nwexcelsolutions.com
 
Back
Top