LinkBack URL
About LinkBacks
this should be so trivial but I will be @##$%^ if I can find it. I have cells that contain either true or false. Rather than have the cell display "TRUE" or "FALSE" I would like the cells to display "1' or "0". How do i format the cells to do this.
this should be so trivial but I will be @##$%^ if I can find it. I have cells that contain either true or false. Rather than have the cell display "TRUE" or "FALSE" I would like the cells to display "1' or "0". How do i format the cells to do this.
How is the True/False being entered into the cell...By way of a formula or manually?
HTH
Regards, Jeff
If it's manual entry (or linked to a control) you will have to use Conditional Formatting to apply a custom number format.
Everyone who confuses correlation and causation ends up dead.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks