LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #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



 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Removing Rows for Printing Frick Excel Worksheet Functions 20 March 10th 06 10:53 PM
Inconsistent Macro Behavior Sarah K Excel Discussion (Misc queries) 4 November 1st 05 10:36 PM
Help: runtime error - Method seriescollection object_chart failed huangx06 Charts and Charting in Excel 3 July 9th 05 12:27 AM
Hiding cells on condition Pennington Excel Worksheet Functions 19 April 21st 05 12:30 AM
update row numbers after different active cells in macros followi. LMIV Excel Discussion (Misc queries) 11 February 16th 05 12:44 AM


All times are GMT +1. The time now is 05:56 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"