Displaying boolean values as 0/1 in Calc

[quasisphere]

Hi,

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?

[karolus]

→Contextmenu→Format Cells→Number→Formatcode 0

[quasisphere]

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