Forum Discussion
Unable to set some cells to two decimal places
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
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.
Hi
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
R
Hi,
That could happen if your cell initially was in text format, applying another format won't convert text to number automatically. Try to stay on such cell, F2 and Enter
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?
R
