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
excel
|validation
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