Hi Mike,
that would work but would make my sheet a lot more complicated. I am
holding out hope for someone giving me a custom format that does the trick.
Thanks your reply.
--
russ


"Mike H." wrote:

I am not much on custom formats, but you could hide the column containing the
"true" or "false" and in the column that is displayed put a formula:

=If(A1=True,"T","F")
where A1 is the hidden column that contains "true" or "False". HTH.