Excel Date Help Please - HotUKDeals
We use cookie files to improve site functionality and personalisation. By continuing to use HUKD, you accept our cookie and privacy policy.
Get the HUKD app free at Google Play

Search Error

An error occurred when searching, please try again!

Login / Sign UpSubmit

Excel Date Help Please

mrsj2008 Avatar
6y, 6m agoPosted 6 years, 6 months ago
Hi,

Is there a way where I can make users enter date only in a certain way - either with a pop up window warning them to do it a different way or something which automatically formats it into 00/00/00 type thing?

I've tried tools, format, cells, date but even though a click on my preferred layout, it still lets me enter date in any old way.

Thanks for your help.
mrsj2008 Avatar
6y, 6m agoPosted 6 years, 6 months ago
Options

All Comments

(6) Jump to unreadPost a comment
Comments/page:
#1
Use Data Validation, great for restricting cel formats
#2
m00bs
Use Data Validation, great for restricting cel formats


+1 - they'll get a popup telling them the date entered is not valid if they try and enter in the wrong format. The only down side is you have to define the start date and end date in the range.

e.g.
Start: 01/01/1900
End 01/01/2100
#3
Thank you, I shall try it now
#4
Brilliant that does work. Have now decided to go one better ......do you have an idea of how I could do a drop down date box instead?
#5
You can use validate to a list, that will allow you to specify a list of valid options elsewhere on the sheet and validate agianst that. The list needs to be complete, seems strange for dates?
#6
mrsj2008
Brilliant that does work. Have now decided to go one better ......do you have an idea of how I could do a drop down date box instead?




I would tend not to bother unless it is a short list of dates.... If it goes on for 20 years thats a lot of dates to go through.. People will do that instead of typing the date, they will search through the listing:x:x

Post a Comment

You don't need an account to leave a comment. Just enter your email address. We'll keep it private.

...OR log in with your social account

...OR comment using your social account

Thanks for your comment! Keep it up!
We just need to have a quick look and it will be live soon.
The community is happy to hear your opinion! Keep contributing!