cell only accept dates

  • Thread starter Thread starter Item Manager
  • Start date Start date
I

Item Manager

Is it possible to setup a cell(s) that will only accept dates and nothing
else? I'm trying to prevent clients from inserting a B in the cell or any
strange charactor unapplicable, but force them to either leave a cell blank
or insert a date. Please help.
 
hi
have you tried data validation? it's quite suited for that.
2003-on the menu bar
date>validation>Allow:date>between 1/1/1900 and 1/1/9999

regards
FSt1
 
Hi,


Select your cells(s) then

Data|Validation
Select 'Date'

Enter any additional parameters for your date.

Mike
 

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

DATE DATA VALIDATION 1
How To Have A Cell Be Blank If... 2
saving only filterd data 6
Automatically Enter Formula in a Cell After Entering Data in Another Cell 0
Trying to run excel vba code when cell value changes from empty to entered value. 1
Prevent alpha character in numeric cell 2
Formula help 1
copy date in a cell if within a date range 1

Back
Top