ericc
04-07-2008, 01:44 PM
Hi
Again a stupid idea, but could be great :
Is it possible to create an input mask in a cell as in Access.
I have a column, where the user is supposed to enter values. But the values should be formatted like this :
00.XX.000000
(2 digits) + dot + (2 capital letters) + dot + (6 digits)
Is it possible to force the user to respect strictly this format ? (and reject any other input)
(without a macro ? :whistle:)
Thanks in advance for your help
ericc
Again a stupid idea, but could be great :
Is it possible to create an input mask in a cell as in Access.
I have a column, where the user is supposed to enter values. But the values should be formatted like this :
00.XX.000000
(2 digits) + dot + (2 capital letters) + dot + (6 digits)
Is it possible to force the user to respect strictly this format ? (and reject any other input)
(without a macro ? :whistle:)
Thanks in advance for your help
ericc