Feb 19 2021 06:11 PM
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 get the cell H6 to format to currency on all sheets, except for the one labelled overall. The sheet labelled overall doesn't require that formatting though.
Thank you for any help.
Feb 19 2021 11:31 PM
Solution@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
Feb 20 2021 12:44 AM - edited Feb 20 2021 01:08 AM
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.
Feb 20 2021 01:28 AM
@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.
Feb 19 2021 11:31 PM
Solution@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