Make T=True in a cell, when I enter T

How can I set a formula to recognize a T and automatically place TRUE in the
cell?

Hi

=EXACT(A1,"T")

--
Regards

Roger Govier


"A357Magnum" <A357Magnum@discussions.microsoft.com> wrote in message
news:E75CE407-C0B6-470B-B73C-48B33053A6E1@microsoft.com...
> How can I set a formula to recognize a T and automatically place TRUE
> in the
> cell?

A formula won't work in the same cell, if that's what you had in mind, but
this formula will work in another cell....

=IF(A1="T","TRUE","")

Vaya con Dios,
Chuck, CABGx3


"A357Magnum" <A357Magnum@discussions.microsoft.com> wrote in message
news:E75CE407-C0B6-470B-B73C-48B33053A6E1@microsoft.com...
> How can I set a formula to recognize a T and automatically place TRUE in
the
> cell?

I sometimes think that it may casue as many problems as it solves but try
Tools > Autocorrect and replace t with TRUE. Note that t will replace both
T and t with TRUE but T will only replace T and it will leave t as it is.
--
HTH

Sandy
sandymann2@mailinator.com
Replace@mailinator.com with @tiscali.co.uk


"A357Magnum" <A357Magnum@discussions.microsoft.com> wrote in message
news:E75CE407-C0B6-470B-B73C-48B33053A6E1@microsoft.com...
> How can I set a formula to recognize a T and automatically place TRUE in
> the
> cell?