Validating/Checking data integrity in cells

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have an excel worksheet:

ID Date Company
Transaction_Code
001 10092007 LG Electonic
000124
002 11092007 Acer Computer
000354
003 11092007 Value System Inc.
000224
004 12092007 Dexty Consultancy
000324
-------------------------------------------------------------------------------------------
My Questions:

I'd like to consturct validating functions for each cell:

- If i input more than 3 digits in the column "ID", there should pop up a
warning

- If my Data format is incorrect (anything other than "ddmmyyyy"), it
should pop pup a warning or something



- Or is there any other way to do it ?
- Any suggestions ?


Thank you so much ^_^!
 
Back
Top