software

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

Hi

=EXACT(A1,quot;Tquot;)

--
Regards

Roger Govierquot;A357Magnumquot; gt; wrote in message
...
gt; How can I set a formula to recognize a T and automatically place TRUE
gt; in the
gt; 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=quot;Tquot;,quot;TRUEquot;,quot;quot;)

Vaya con Dios,
Chuck, CABGx3quot;A357Magnumquot; gt; wrote in message
...
gt; How can I set a formula to recognize a T and automatically place TRUE in
the
gt; cell?
I sometimes think that it may casue as many problems as it solves but try
Tools gt; 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
with @tiscali.co.ukquot;A357Magnumquot; gt; wrote in message
...
gt; How can I set a formula to recognize a T and automatically place TRUE in
gt; the
gt; cell?