View Single Post
  #10   Report Post  
Posted to microsoft.public.excel.misc
Bob Phillips Bob Phillips is offline
external usenet poster
 
Posts: 1,726
Default Formatting TRUE/FALSE to 1/0


"Ron Rosenfeld" wrote in message
...
On Mon, 19 Feb 2007 06:57:10 -0800, Smallweed
wrote:


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.


Actually, it is any non-zero number