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

Reboot

Copper Contributor

Feb 16, 2019

Thanks for the reply but no joy I'm afraid.

I highlighted the cell (Z326) and hit Fn+F2, which made the cells formula [=IMSUB(U324,Z325)] appear in the cell. I then hit Enter, which just made the green selection border around the cell move one cell down, so the cell below Z326 became selected. This had no effect on the number in cell Z326, still showing to three decimal places.

What I've noticed, however, is that this problem is only occurring in cells that have =IMSUB in the formula; all the others without IMSUB work fine.

Any ideas?

SergeiBaklan

Diamond Contributor

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

Reboot
Copper Contributor
Feb 17, 2019
That's done the trick! Thanks for your help.

Cheers

R