Forum Discussion
Solved
Cell Formating
Hello, I had tech support help me via quick assist for this issue. He wasn't able to correct it and suggested posting here. I have included the spreadsheet that I am talking about. I am unable to g...
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
You could convert the text to numbers by prefixing by a double negation but, as Riny_van_Eekelen suggests, the use of complex arithmetic to capture stock dealings is not to be recommended.
Personally, I would also convert all the tabular data to Excel Tables and use sheet-local Names to reference the non-tabular values.