I want to allow entries that are in the form DR9090, where the D can be
replaced by any letter, the R must always be an R and the other four must be
digits (not spaces) and all six are required (In access the input mask
equivalent is L"R"0000). In older versions of Excel (I use 2003) there used
to be a list of codes (e.g. #, ? etc) and what they mean, but i can't find it
in this version. I am not able to download example files because of internet
permissions, but I'd really like to know if there's a list somewhere of all
the available codes that i could use, and if not, what the formula should be
for this particular validation.

I will need to do the same to mirror the Access input mask LL??"-"000

thanks!