View Single Post
 
Old 02-27-2011, 02:22 PM
Kimberly Kimberly is offline Windows 7 Office 2010 (Version 14.0)
Expert
 
Join Date: May 2010
Posts: 517
Kimberly is on a distinguished road
Default

Sorry, as far as I know, you cannot prevent the behavior you are describing. You can use Data validation to force typed entries to be dates, but validation is not triggered by pasting, so I think this is of limited value to you. (Also, dates are just numbers, so numbers also get a pass.)
Reply With Quote