Validating or checking data integrity function
 

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 ^_^!


--
Allen Phailat Wongakanit

Validating or checking data integrity function
 

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


"ali" wrote:

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 ^_^!


--
Allen Phailat Wongakanit

Validating or checking data integrity function
 

big thanks!!Mike, you rock !! !
--
Allen Phailat Wongakanit


"Mike H" wrote:

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


"ali" wrote:

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 ^_^!


--
Allen Phailat Wongakanit