version 13.1 (7037.0.101) incorrect currency formatting

Question

version 13.1 (7037.0.101) incorrect currency formatting

With the latest numbers update, version 13.1 (7037.0.101), cells that are formatted as currency with two decimal places show more than two decimal places. This appears to be when the formatted cell contains an equation that includes multiplication or division. This appears to only effect newly updated cells, previous cells with the same equation display correctly.

I can't find anywhere on the apple support site to send them an email. I don't want to spend time on the phone with them for this issue....

MacBook Pro 13″, macOS 12.6

Posted on Jul 20, 2023 07:55 AM

Reply

Answer 1

Badunit

Level 7

29,910 points

Jul 20, 2023 10:43 AM in response to Rob Colclaser

I have not seen that here. With more information I'll try to reproduce the problem and maybe see what's going on. Please post a screenshot showing a currency cell selected that has more than 2 decimal places and the formatting sidebar showing it set to only two places. And post the formula in that cell and the inputs to the formula, if not visible in the screenshot. When you say "newly updated" do you mean an input to the formula recently changed? Any other info on how to make it occur would be helpful, if you know of anything. If we can figure out how to make it happen consistently, the bug report(s) we provide will be more useful.

Reply

version 13.1 (7037.0.101) incorrect currency formatting

Similar questions