formatting cells with boolean values
 

I know this is not the right forum for this question but I can't seem to find
it anywhere. I have a cell in a sheet that contains a boolean value. It is
displayed as either "TRUE" or "FALSE". What is the custom format to display
the two values as "T" or "F"?
--
russ

formatting cells with boolean values
 

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.

formatting cells with boolean values
 

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.