I am stumped on date formatting.
I have a column that requires the user to input the date. They can type in 123105, 12312005, 12/31/05, etc....pretty much any format they want.
If they type with the / or - between each mmddyy, I have no problem. But when they type in only the numbers, Excel sees them as the serial number and converts the entry to the serial number data. For example 123105 would be 1/17/2237. I want to be able to show it as 12/31/05.
I've formatted the column to date mm/dd/yy and use data validation of date greater than 1/1/1900.
Thanks for any help.
I have a column that requires the user to input the date. They can type in 123105, 12312005, 12/31/05, etc....pretty much any format they want.
If they type with the / or - between each mmddyy, I have no problem. But when they type in only the numbers, Excel sees them as the serial number and converts the entry to the serial number data. For example 123105 would be 1/17/2237. I want to be able to show it as 12/31/05.
I've formatted the column to date mm/dd/yy and use data validation of date greater than 1/1/1900.
Thanks for any help.