Re: Showing number as binary

2020-02-19 Thread Johnny Rosenberg
Den ons 19 feb. 2020 kl 22:18 skrev Brian Barker : > At 21:08 19/02/2020 +0100, Johnny Rosenberg wrote: > >Here's one way. I don't have Apache OpenOffice so I can't test it, > >but I tested it with LibreOffice and I think it would work in Apache > >OpenOffice too: > >=VALUE(BASE(42;2)) > >Now form

Re: Showing number as binary

2020-02-19 Thread Brian Barker
At 21:08 19/02/2020 +0100, Johnny Rosenberg wrote: Here's one way. I don't have Apache OpenOffice so I can't test it, but I tested it with LibreOffice and I think it would work in Apache OpenOffice too: =VALUE(BASE(42;2)) Now format the cell like the following: [...] " " Note that if o

Re: Showing number as binary

2020-02-19 Thread Andrew Pitonyak
Can I just say that this is for certain the best solution I have seen to accomplish this. Did not know that you could do that. On Wednesday, February 19, 2020 15:16 EST, Johnny Rosenberg wrote:  Den ons 19 feb. 2020 kl 21:08 skrev Johnny Rosenberg : > Den ons 19 feb. 2020 kl 10:09 skrev Andr

Re: Showing number as binary

2020-02-19 Thread Johnny Rosenberg
Den ons 19 feb. 2020 kl 21:08 skrev Johnny Rosenberg : > Den ons 19 feb. 2020 kl 10:09 skrev Andrea Vt : > >> Hi all :-) >> >> Is there a way to show a number as binary with a separation? >> > Yes, there seems to be. > >> >> E.g. 42 as 0010 1010. (BASE(42;2;8) -> 00101010) >> >> Thanks and have a

Re: Showing number as binary

2020-02-19 Thread Johnny Rosenberg
Den ons 19 feb. 2020 kl 10:09 skrev Andrea Vt : > Hi all :-) > > Is there a way to show a number as binary with a separation? > Yes, there seems to be. > > E.g. 42 as 0010 1010. (BASE(42;2;8) -> 00101010) > > Thanks and have a nice day > Have a nice day you too. And maybe I should answer the qu

Re: Showing number as binary

2020-02-19 Thread Brian Barker
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

Re: Showing number as binary

2020-02-19 Thread Andrew Pitonyak
I wrote a macro to convert to / from binary. You cannot specify the base or the number of digits. I don't remember if it is published in OOME or AndrewMacro, but but are on my web site for download. ⁣Sent from BlueMail ​ On Feb 19, 2020, 4:09 AM, at 4:09 AM, Andrea Vt wrote: >Hi all :-) > >Is

Showing number as binary

2020-02-19 Thread Andrea Vt
Hi all :-) Is there a way to show a number as binary with a separation? E.g. 42 as 0010 1010. (BASE(42;2;8) -> 00101010) Thanks and have a nice day Andrea - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For