Can I change the way truth values are displayed?

Hi!

By default, truth values are displayed as "TRUE" or "FALSE" in Excel. Is
there a way to change this? E.g., can I have just a e.g. an "x" instead of
"TRUE" and a "." only instead of "False"?

Of course, I could use formulas like...

A1=IF(<Condition>,"x";".")

....but this way, I'd have to use

A2=IF(A1="x"; ..., ...)

....instead of the more simple

A2=IF(A1; ..., ...)

So, can I change the way Excel displays truth values?

Ingolf.

Don't believe this can be done. You'd have to use a formula like your example.

"xirx" wrote:

> Hi!
>
> By default, truth values are displayed as "TRUE" or "FALSE" in Excel. Is
> there a way to change this? E.g., can I have just a e.g. an "x" instead of
> "TRUE" and a "." only instead of "False"?
>
> Of course, I could use formulas like...
>
> A1=IF(<Condition>,"x";".")
>
> ....but this way, I'd have to use
>
> A2=IF(A1="x"; ..., ...)
>
> ....instead of the more simple
>
> A2=IF(A1; ..., ...)
>
> So, can I change the way Excel displays truth values?
>
> Ingolf.
>
>
>

If you start your formula with a =--(formula), then it will return a 1 for
true, 0 for false.

If you format your cells/custom

X;;O

it will show X when true, O when false

Beege

"xirx" <xirx@gmx.de> wrote in message
news:44d0c905$0$15872$4d4ebb8e@read.news.de.uu.net...
> Hi!
>
> By default, truth values are displayed as "TRUE" or "FALSE" in Excel. Is
> there a way to change this? E.g., can I have just a e.g. an "x" instead of
> "TRUE" and a "." only instead of "False"?
>
> Of course, I could use formulas like...
>
> A1=IF(<Condition>,"x";".")
>
> ...but this way, I'd have to use
>
> A2=IF(A1="x"; ..., ...)
>
> ...instead of the more simple
>
> A2=IF(A1; ..., ...)
>
> So, can I change the way Excel displays truth values?
>
> Ingolf.
>

Nice workaround. Thank you very much!


"Beege" <bwgilmanhah@comcast.net> wrote in message
news:EfqdncXY8qeDT03ZnZ2dnUVZ_vednZ2d@comcast.com...
> If you start your formula with a =--(formula), then it will return a 1 for
> true, 0 for false.
>
> If you format your cells/custom
>
> X;;O
>
> it will show X when true, O when false
>
> Beege
>
> "xirx" <xirx@gmx.de> wrote in message
> news:44d0c905$0$15872$4d4ebb8e@read.news.de.uu.net...
>> Hi!
>>
>> By default, truth values are displayed as "TRUE" or "FALSE" in Excel. Is
>> there a way to change this? E.g., can I have just a e.g. an "x" instead
>> of "TRUE" and a "." only instead of "False"?
>>
>> Of course, I could use formulas like...
>>
>> A1=IF(<Condition>,"x";".")
>>
>> ...but this way, I'd have to use
>>
>> A2=IF(A1="x"; ..., ...)
>>
>> ...instead of the more simple
>>
>> A2=IF(A1; ..., ...)
>>
>> So, can I change the way Excel displays truth values?
>>
>> Ingolf.
>>
>
>

xirx,

Thanks for feeding back, glad I could help.

Beege

"xirx" <xirx@gmx.de> wrote in message
news:44d728b6$0$426$4d4ebb8e@read.news.de.uu.net...
> Nice workaround. Thank you very much!
>
>
> "Beege" <bwgilmanhah@comcast.net> wrote in message
> news:EfqdncXY8qeDT03ZnZ2dnUVZ_vednZ2d@comcast.com...
>> If you start your formula with a =--(formula), then it will return a 1
>> for true, 0 for false.
>>
>> If you format your cells/custom
>>
>> X;;O
>>
>> it will show X when true, O when false
>>
>> Beege
>>
>> "xirx" <xirx@gmx.de> wrote in message
>> news:44d0c905$0$15872$4d4ebb8e@read.news.de.uu.net...
>>> Hi!
>>>
>>> By default, truth values are displayed as "TRUE" or "FALSE" in Excel. Is
>>> there a way to change this? E.g., can I have just a e.g. an "x" instead
>>> of "TRUE" and a "." only instead of "False"?
>>>
>>> Of course, I could use formulas like...
>>>
>>> A1=IF(<Condition>,"x";".")
>>>
>>> ...but this way, I'd have to use
>>>
>>> A2=IF(A1="x"; ..., ...)
>>>
>>> ...instead of the more simple
>>>
>>> A2=IF(A1; ..., ...)
>>>
>>> So, can I change the way Excel displays truth values?
>>>
>>> Ingolf.
>>>
>>
>>
>
>