At 10:09 19/02/2020 +0100, Andrea Vt wrote:
Is there a way to show a number as binary with a separation? E.g. 42 as 0010 1010. (BASE(42;2;8) -> 00101010)
You do mean the binary equivalent of 42 but split into two groups - not the separate binary equivalents of the digits 4 and 2 - right?
Try: =LEFT(BASE(A1;2;8);4)&" "&RIGHT(BASE(A1;2;8);4) I trust this helps. Brian Barker --------------------------------------------------------------------- To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org
