Ask Your Question

How to format cells for Hex numbers? [closed]

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

juztreality gravatar image

updated 2020-08-07 22:54:24 +0200

Alex Kemp 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?



edit retag flag offensive reopen merge delete

Closed for the following reason question is not relevant or outdated by Alex Kemp
close date 2020-08-07 22:55:24.842048

3 Answers

Sort by » oldest newest most voted

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

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, here, and also in the

edit flag offensive delete link more

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.

edit flag offensive delete link more

Question Tools

1 follower


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

Seen: 25,344 times

Last updated: Oct 20 '16