| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
custom format for boolean values
I need to display boolean worksheet values not as TRUE or FALSE, but as "Y"
and "N" without the use of conditional formatting, macros or functions; a custom format. The custom format: "Y";;"N"; works if the field value is numeric, but not for boolean expressions or values. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how to paste values created by custom format? | Excel Discussion (Misc queries) | |||
| Custom Cell format to mimic time format | Excel Discussion (Misc queries) | |||
| how do I add phone number format as a permanent custom format? | Excel Discussion (Misc queries) | |||
| Comparing text and returning boolean values | Excel Discussion (Misc queries) | |||
| Anyone know how to format cells as yes/no boolean logic? | New Users to Excel | |||
Threaded Mode
