vivekanand
New Member
- Joined
- Jun 23, 2011
- Messages
- 1
i need to do certain validations in exel2007.
validations like limit on number of charecters can be easily done using DATA VALIDATION .
But i need to restrict a umber to 12 digits with out decimal point.
If decimal point is present total no of digits before and after decimal point must be less than 12(ex:1234567890.12).If decimal point is not provided total digits must be less than 12(ex:123456789012).please tell how to validate it.i am completely unaware of excel macros.
validations like limit on number of charecters can be easily done using DATA VALIDATION .
But i need to restrict a umber to 12 digits with out decimal point.
If decimal point is present total no of digits before and after decimal point must be less than 12(ex:1234567890.12).If decimal point is not provided total digits must be less than 12(ex:123456789012).please tell how to validate it.i am completely unaware of excel macros.
