Formatting TRUE/FALSE to 1/0
On Mon, 19 Feb 2007 06:57:10 -0800, Smallweed
wrote:
Actually the "TRUE";;"FALSE" format has suddenly started working for me for
typed zeroes in a new sheet.
Yes it should. You are formatting a number to display TRUE or FALSE. In your
original request, you wanted to opposite (type TRUE or FALSE, and display a
number).
Of course, any positive number will display TRUE; so if someone accidently
typed in a 2 or 10, you might see TRUE, but any mathematic operation would
perhaps not give the expected results.
You could perhaps use the custom format:
[=1]"TRUE";[=0]"FALSE";General
That would display TRUE for a typed in 1; FALSE for a typed in 0; and the
actual value if you typed in anything else.
--ron
|