Excel is a number cruncher. Data validation in Excel is, for all practical
purposes, almost non-existent unless you use VBA code. Even the data
validation on the Data Menu which allows some validation is weak as you can
paste bad data into a cell even though the cell has data validation because
the data validation is ignored on a paste. Go figure! So, if you really need
to validate your data, learn Visual Basic for Applications.

Regards,

Dave

..

"Fritz" wrote in message
...
Thanks that works fine as long as it take 2 cells to do it in. In Access
we
used to be able to design a "special format" for such.

"Dave Thomas" wrote:

Use the UPPER function: if "a1b 6c3" (no quotes, of course) is entered
in
A1, then in B1, =UPPER(A1) produces A1B 6C3

Regards,

Dave


"Fritz" wrote in message
...
I would like to type is our Canadian Postal Code and have a special
format
that forces the right entry. Our Postal Code consists of
3 characcters a space and 3 more character. Ie "S0L 1G9".
It is always a "UPPERCASE LETTER, number, UPPERCASE LETTER, space,
number,
UPPERCASE LETTER, number".

I would like to enter it in lower case but have it converted to upper
case.
Is this possible. Thanks