date format using dot / period

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
 
P

Peo Sjoblom

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
 

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

Odd date format 3
date/serial numbers-help please 1
General vs Date format question 4
How do I change dates input as 20080426 to date format in Excel? 7
date format in excel imported from an SQL DB. 2
Date format 2
Date Format 3
Formula to fill cells based on Date of Arrival and Date of Departure 1

Top