View Single Post
  #10   Report Post  
Posted to microsoft.public.excel.misc
Ron Rosenfeld Ron Rosenfeld is offline
external usenet poster
 
Posts: 5,651
Default 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