Forum Discussion

Copper Contributor

Feb 15, 2019

Solved

Unable to set some cells to two decimal places

Hi The attachment shows an account book I'm working on. The problem is that I can't get some cells to show to only two decimal places, while others will. Column S is an amount ex-tax, column ...

excel

Formulas and Functions

SergeiBaklan
Feb 16, 2019
Oops, sorry, I missed first time you use IMSUB. That function returns the difference of two complex numbers as the text (https://support.office.com/en-us/article/imsub-function-2e404b4d-4935-4e85-9f52-cb08b9a45054). You don't need it all. Instead of =IMSUB(U324, Z325) use simply

=U324-Z325

SergeiBaklan

Diamond Contributor

Feb 16, 2019

Hi,

Based on your screenshort currency format is not set for these cells. Try to stay on any of these cells in question and press Ctrl+1, formatting window shall show

if everything is correct with formatting. If not, change the format here.

Reboot

Copper Contributor

Feb 16, 2019

Thank you for your reply.

As shown in screenshot 1, one of the target cells (Z326) is selected, and you can see that it is set to currency, to two decimal places. However, for some reason, this, and the other cells that are not cooperating (such as N327), will not act as though they are currency cells to two decimal places; as shown in screenshot 2, they seem to act as though they are set to 'general'.

Any ideas how to rectify this?

Regards