List of validation codes

B

Bobbin

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!
 
J

Jim Cone

B,

I believe you are looking for 'Character Codes'.
In Excel 97 vba help that is what they are called.
In XL 2002 you must look for 'Character Set' in vba help.
Try that in XL2003 (or some variation of it)

If you are not writing code then use the Char function for numbers 1 to 255
to get your list....

=CHAR(65) Displays the 65 character in the set (A)

Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware



"Bobbin" <[email protected]>
wrote in message
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!
 
Top