View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Harry Sampson
 
Posts: n/a
Default XL 2003, True, False, 1, 0

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