Check box problem

  • Thread starter bhrosey via OfficeKB.com
  • Start date
B

bhrosey via OfficeKB.com

I'm using a check box to return a value and that part works OK, but in the
cell that the box is in is showing the words True or False behind the box.
How do I get rid of this??

Thanks for any help
 
D

Dave Peterson

Remove the cell link if you want.

If you need to keep the information, but don't want to see it, you could use a
cell link in a different cell (hidden or far away)

or
you could give that cell a custom format:
format|cells|Number tab|Custom category
;;;
(3 semi colons)

The value will still be there (visible in the formula bar) and you can use it
other formulas, but it'll look blank in the worksheet.
 
B

bhrosey via OfficeKB.com

Dave said:
Remove the cell link if you want.

If you need to keep the information, but don't want to see it, you could use a
cell link in a different cell (hidden or far away)

or
you could give that cell a custom format:
format|cells|Number tab|Custom category
;;;
(3 semi colons)

The value will still be there (visible in the formula bar) and you can use it
other formulas, but it'll look blank in the worksheet.
Click to expand...

Thanks, that helped a lot!!!
I'm using a check box to return a value and that part works OK, but in the
cell that the box is in is showing the words True or False behind the box.
Click to expand...
[quoted text clipped - 5 lines]
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.aspx/ms-excel/200706/1
Click to expand...
Click to expand...

--
John 3:16 "For God so loved the world that He gave His only begotten Son, so
that whoever believes in Him shall not parish, but have eternal life"

Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.aspx/ms-excel/200706/1
 
Top