How to Validate Pasted Dates in Excel

Posted by jimdrang on Stack Overflow See other posts from Stack Overflow or by jimdrang
Published on 2010-05-11T16:40:06Z Indexed on 2010/05/11 16:44 UTC
Read the original article Hit count: 234

Filed under:
|

I want to validate pasted dates to remove /'s and ensure the year is 4 digits and when users paste them in it overwrites my excel validation.

So, If a user pastes 05/19/10 into a cell, I would like it to convert to 05192010 or at least give an error if this is not possible.

I don't know enough VB to add sheet-wide code that does this and I'm not sure if it would work when users paste multiple cells at a time.

© Stack Overflow or respective owner

Related posts about excel

Related posts about validation