formatting cells with boolean values

  • Thread starter Thread starter Russ
  • Start date Start date
R

Russ

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"?
 
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.
 
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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Pass value variable to worksheet event 3
Excel VBA 1
count cells with diagonal borders 3
Unhide sheet, copy and rename new sheets from list, rehide sheet 8
conditional format fails when copied 1
Workbook_BeforeSave 8
Creating a UDF to search a cell's formula 8
Boolean Declaration 4

Back
Top