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:
[...]
0000" "0000
Note that if omitting the quotes, typing 0000 0000 in that field
will fail, (the cell will display 00 101 010). I'm not sure why
though. As I said, I tested this in LibreOffice, hopefully it will
work in Apache OpenOffice too.
For what it's worth, the version without quotes works too in my OpenOffice.
At 21:16 19/02/2020 +0100, Johnny Rosenberg wrote:
After some more experimenting I found this way, ...
And the cell formula looks like this:
=TEXT(VALUE(BASE(42;2));"0000"" ""0000")
Again,
=TEXT(VALUE(BASE(42;2));"0000 0000")
works in my OpenOffice.
Brian Barker
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
