When using base 12 in Numbers, how to make Numbers DISPLAY two digits beyond the radix point?

Thank you for responding! I'd love to have someone else also working on this to see if we can find a solution!

Ah. No, I don't want to use BASETO. I've used that in various spreadsheets, and it slows down calculations once there is a regular amount of data in the spreadsheet. I'm using Cell/Data Format/Base: 12 So, the entire spreadsheet is set to duodecimal (which I call dozenal, because of the Dozenal Society of America).

I have several entire sheets properly calculating in duodecimal, and in most cases, whole numbers is fine for what I'm doing (a multiplication table, for example, always yields whole numbers). But for a division table, or when using ROOT and I want to use to the 0.6 power (I want the 0.6 to pull from a cell, so I can easily change the 0.6 to use any root), then I need to see the digits to the right of the separator point. I am calling it a "radix point" because technically "decimal point" is only valid when using base ten. So, whatever base one is using, the period (in the U.S.) is called a radix point, or a separation point, etc.

The so-called "fractional" part is because it is a fraction of one. In decimal, that would be the part to the right of the decimal point. If 0.5, then that is 1/2 of one. If 0.25, then that is 1/4 of one, et cetera. So, they are fractions of the whole number one.

I am mostly interested in the calculations. But, when the "decimal fraction" (really a dozenal fraction a.k.a. duodecimal fraction) to the right of the point is not zero, I really want to see it and not a rounded value. So, if we were using decimal, it would be 0.5, and I could set the decimal fraction part to two digits, and it would show 0.50. But, when using the "Numeral System" format, changing the "Places" doesn't change the fractional part (less than one), it changes how many whole number digits are shown. So, if the answer is 2, it will show 0002 if I choose 4 Places.

I am entering numbers directly into the Numbers spreadsheet cells. I'll enter 10 into a cell, then 5 into another cell, use a subtract formula, and it will yield 7. I will enter 9 in a cell, then 3 in another cell, and a formula calling and summing both cells will yield 10. Also, when I DO create formulas that I know will yield a fraction to the right of the separation point, it seems to correctly calculate, because it rounds (either up, or down), and does so correctly. I also just entered 0.6 (one half) into a cell, then below that entered 0.4, and then used a SUM formula in the cell below. It yields 1. Then I changed the 0.4 to 1.4, and it yields 2. Although I can't be certain just from that that it is not 0.9 and rounding to 1, then 2.4 and rounding to 2, I am all but certain that the values in the cells are correct. They are all less than one, because they are right of the "decimal point". So, 0.3 is 1/4, 0.4 is 1/3, 0.6 is 1/2, etc..

What is not working is that I can't see those "decimal" numbers. It always rounds, so I always see a whole number. And, I cannot figure out how to change that. It isn't being shown as an option where it normally would be for regular decimal spreadsheets...

By the way, this feature might be new. I've looked in the past for a way to easily set an entire spreadsheet to duodecimal, and didn't find anything. This is the first time that I've found one. Thankfully, I'm all Apple products, so I use Numbers a lot. I only use Excel (through Parallels) when absolutely must for work.

Thank you.

But, if I use NUM2BASE to add displayed decimals, that, too, will probably slow down the sheets once too much data is in.

Why in the world would Apple create a spreadsheet that doesn't display the fractional part of numbers? I sincerely do appreciate even having a spreadsheet that works properly when set to duodecimal. I'm thankful, and I'll use it as-is, and not worry about dozenal fractional displays. But, it would make sense if they eventually did display...