Date format

In MS Access it is possible to format a cell with __/__/____ so that it is only possible to enter a date. Is this possible in Excel. 

Spindrift,

You want Data Validation.  This allows you to limit what people type into a cell.  Unfortunately paste operations aren't limited (a topic of much discussion).

David B.

Spindrift

I'm sure David's answer is the way to go if you want to validate data. To complete the answer, Access has 'placeholders', Excel does not.

You could also use a Worksheet_Change() event to validate the input into a cell and if you could validate as a date (4, 5 or six numbers not exceeding 28, 29, 30, 31 and 12 in the right places, etc) then format it as one?

Neither solution is like the placeholder functionality in Access, but both offer solutions.

Many thanks for your info. I had completely forgotten about Data Validation and I have no idea what Worksheet_change is, but I shall now look it up.

Peter