Input mask

[ericc]

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 ? )


Thanks in advance for your help

ericc

[rory]

You could do it with a complicated Data Validation formula but it would be easier with VBA if that's an option?

[ericc]

Hmm, Apparently I will not have the choice ...

I just wonder why Excel don't have a better input mask feature as Access, when users are supposed to enter values

Thanks anyway

ericc

[rory]

Access is a database program, Excel isn't. You can use data validation, or you can use userforms to assist with data entry but you won't find a lot of the features of a database program in Excel because that's not really what it's for, even if people do use it that way.