Ask Your Question

Displaying boolean values as 0/1 in Calc

asked 2015-04-29 14:54:06 +0100

quasisphere gravatar image

updated 2015-04-29 14:55:14 +0100


I have an excel file I imported in Calc and originally the boolean values displayed as 0/1. Now after I moved some rows the boolean values on the rows changed to TOSI/EPÄTOSI (Finnish words for TRUE/FALSE). These words are long and it is harder to check by a glance what the boolean array looks like.

Is there a way to have boolean values always displayed as 0/1?

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted

answered 2015-04-29 15:10:14 +0100

karolus gravatar image

→Contextmenu→Format Cells→Number→Formatcode 0

edit flag offensive delete link more


Thanks, that works. I also found the "Clear direct formatting" menu item that seems to do the job.

quasisphere gravatar imagequasisphere ( 2015-04-29 15:19:50 +0100 )edit
Login/Signup to Answer

Question Tools

1 follower


Asked: 2015-04-29 14:54:06 +0100

Seen: 2,304 times

Last updated: Apr 29 '15