2 Letter Formatting

[farewinners]

Hello, my employee numbers start with 2 letters followed by numbers. Is there a way to format so that the first two letters are capitalized. Thanks in advance.

 

[bobsan42]

=UPPER(A1)
?
As far as formatting goes - i think excel does not have such capabilites

 

[alansidman]

In your table for the field you wish to have in this manner, type the greater than sign (>) in the format property.

 

[bobsan42]

ooops.
this is an access question.
sorry

 

[farewinners]

In your table for the field you wish to have in this manner, type the greater than sign (>) in the format property.

the format property will only allow me to enter in 1 (>)