View Single Post
  #2   Report Post  
Dave Peterson
 
Posts: n/a
Default

You mean Checkboxes?

You can use a helper cell:

=if(a1=true,"Yes","No")

Then hide that linkedcell (if you want).

Gldenboy2 wrote:

I have a long colum full of textboxes in excel. When the boc is checked it
returns true, and false for unchecked. I would like to change this so that
it returns Yes for checked and No for unchecked. How can I make this happen


--

Dave Peterson