Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 02-27-2011, 02:22 PM
Kimberly Kimberly is offline Protecting the formatting and formulas in a worksheet Windows 7 Protecting the formatting and formulas in a worksheet 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
Reply



Similar Threads
Thread Thread Starter Forum Replies Last Post
Protecting the formatting and formulas in a worksheet Protecting or hiding ASK fields SaneMan Word 1 01-14-2011 08:16 PM
Protecting the formatting and formulas in a worksheet IF Formulas mizzamzz Excel 1 07-08-2010 02:32 AM
Protecting the formatting and formulas in a worksheet Protecting your logo in Word TimD Word 5 04-29-2010 07:10 AM
Protecting the formatting and formulas in a worksheet Protecting image in word 2007. aligahk06 Word 1 10-12-2009 08:22 AM
Protecting Word Document by restricting access permissions! user Word 0 11-20-2008 01:21 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 11:20 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft