Ask Your Question
0

How to format cells for Hex numbers?

asked 2016-10-19 22:49:33 +0200

juztreality gravatar image

How does one format cells in Calc for Hex numbers? There are quite a few included examples for different types of numbers but none for Hex, Octal, or Binary. Is this even possible?

Thanks,

juztreality

edit retag flag offensive close merge delete

3 Answers

Sort by » oldest newest most voted
2

answered 2016-10-19 23:48:45 +0200

erAck gravatar image

No, there are no number formats for other bases. However, you can use the spreadsheet function BASE for this.

edit flag offensive delete link more
1

answered 2016-10-19 23:48:22 +0200

m.a.riosv gravatar image

There are not such formats, but you can convert the numbers with functions like BIN2DEC, BIN2HEX, BIN2OCT, DEC2BIN, DEC2HEX, DEC2OCT, HEX2BIN,HEX2DEC, HEX2OCT, OCT2BIN, OCT2DEC, OCT2HEX. With the function wizard you can look for them easily and call the help.

https://help.libreoffice.org/Calc/Add...

edit flag offensive delete link more
1

answered 2016-10-20 14:23:59 +0200

Lupp gravatar image

Since this is not the first request in the field and highly appreciated contributors posted answers I will try to draw their attention to this thread in another forum created 13 months ago.

Finding an answer to the question I posted there would open a way to create solutions by user code at least to the not so samll complete field of questions concerning (very) special desired number formats. This without requesting the implementation of a new feature every other day.

(Please note that the code contained in an example attached to the mentioned post is very crude and experimental.)

(There were related topics in the late libreofficeforum.org, here, and also in the forum.openoffice.org/en.)

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2016-10-19 22:49:33 +0200

Seen: 13,413 times

Last updated: Oct 20 '16