Hi,

I am using a range of formulas which all depend on the format accuracy of the entered data. Now, since it is not me who is entering the data, i am looking for a way to force the user to enter according to the format.

For example, the cell content should for dates dd/mm/yyyy but some users enter it as yyyy.mm.dd or dd-mm-yyyy or even mm/dd/yy. basically i have 3 different formats which i first need to sort out and standardize before the excel formulas can recognize the date. Nightmare.

Any thoughts on how I can let excel check if the entered values are a date (i use pre-defined cell contents already) and maybe throw an error at them if its not? I need this for a date column and a currency column (currency: 100.99 is what i need, 100++ is what i get....)

Thanks,
A2k