Validating or checking data integrity function

  • 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 ^_^!
 
Ali,

For the ID apply a custom format of
000
to the cell and then Data|Validation, Select whole number-between and set it
to 1 to 999.

For the date cell apply a custom format of ddmmyyyy and set data validation
as above but this time only to accept dates.

Mike
 
Back
Top