XL 2003, True, False, 1, 0

Giganews Newsgroups
Subject: XL 2003, True, False, 1, 0
Posted by:  Harry Sampson (nospam@no1spam.com)
Date: Thu, 25 May 2006

Hi,

I am using XL 2003 and whenever I enter TRUE or FALSE into a spreadsheet
cell, it immediately turns to 1 or 0.  I made sure that the number format is
general.  And I created a "boolean" style, again putting the number format
to general.  But I still get only 1 or 0 displayed in the cell, even though
the formula bar entry shows TRUE or FALSE.  How do I get the spreadsheet to
display TRUE or FALSE?

I inherited this spreadsheet, so I am not sure what setting caused this to
happen.

Best regards,
Kevin

Replies