Hello,
I would need to create a validation rule that allows to enter data in time format only and on another column in date format only! .. Coul someone help me on that? ..
thx,
Nedy
Hello,
I would need to create a validation rule that allows to enter data in time format only and on another column in date format only! .. Coul someone help me on that? ..
thx,
Nedy
Are you wanting specific date and time formats? If so, what are they?
MVP (Excel 2008-2010)
Post a workbook with sample data and layout if you want a quicker solution.
To help indent your macros try Smart Indent
Please remember to mark threads 'Solved'
Exaclty :
for time : hh:mm
for date : dd/mm/yyyy