| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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. |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| custom format for boolean values | Excel Discussion (Misc queries) | |||
| Boolean Values in Pivot Table | Excel Discussion (Misc queries) | |||
| Evaluate boolean values as 1 or 0 | Excel Worksheet Functions | |||
| Comparing text and returning boolean values | Excel Discussion (Misc queries) | |||
| Boolean formula for Conditional Formatting | Excel Programming | |||
Linear Mode
