Forcing date format (dd/mm/yyyy) using data validation

**reddwarf** · 08-14-2009, 05:44 AM

Hi,
First post, great site and glad I found it - a great resource of tips and tricks!

I have a question. I need users to enter dates into a spreadsheet (dd/mm/yyyy) but I need the spreadsheet to trap the error should an incorret date be entered, I know this can be done via data validation and believe me when I say I have searched this site and googled Google but I cannot find an exact answer.

Can someone help?

Thanks

**DonkeyOte** · 08-14-2009, 05:53 AM

When applying the validation use the Date option and apply Start & End dates accordingly.

Format the cell to use dd/mm/yyyy format - once valid date is entered it will be formatted as required regardless of how it was input (eg 1/2/9 will display correctly as 01/02/2009)

**reddwarf** · 08-14-2009, 09:37 AM

Thanks DonkeyOte,
Worked a treat - I never knew it was that simple!

**arthurbr** · 08-14-2009, 09:58 AM

If you are satisfied with the solution(s) provided, please mark your thread as Solved.

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save

Thread: Forcing date format (dd/mm/yyyy) using data validation

Thread Tools

Display

Forcing date format (dd/mm/yyyy) using data validation

Re: Forcing date format (dd/mm/yyyy) using data validation

Re: Forcing date format (dd/mm/yyyy) using data validation

Re: Forcing date format (dd/mm/yyyy) using data validation

Thread Information

Users Browsing this Thread

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions