Forum Discussion
Cell Formating
Kcirevam I wonder how you came about to use the IMSUB function. Its use is to work with complex numbers as described in the article linked below. The result is a text, not a number and therefore can not be formatted as a number in any way.
You should use =E6-G6 in order to subtract two regular numbers.
https://support.microsoft.com/en-us/office/imsub-function-2e404b4d-4935-4e85-9f52-cb08b9a45054
Kcirevam I wonder how you came about to use the IMSUB function. Its use is to work with complex numbers as described in the article linked below. The result is a text, not a number and therefore can not be formatted as a number in any way.
You should use =E6-G6 in order to subtract two regular numbers.
https://support.microsoft.com/en-us/office/imsub-function-2e404b4d-4935-4e85-9f52-cb08b9a45054
Riny_van_EekelenI came to use that formula by being very new to this. Lol, I did not realize I could do it the way you recommended. That did fix the problem. Thank you for the help.