Forum Discussion
Andrew McCracken
Sep 13, 2018Copper Contributor
Finding Total of all Sums
Hello, So i'm extremely new to Excel (like yesterday was my first time using it) however i suddenly need to use it for work. so essentially I'm making a sheet to track our output and have made sums f...
Andrew McCracken
Sep 13, 2018Copper Contributor
so the text is causing it to zero? that was what i was assuming. so you suggest i just put the text in an adjacent cell?
SergeiBaklan
Sep 13, 2018Diamond Contributor
In an adjacent cell or apply custom format to your numbers like this
For the F1 is General format, for the G1 - custom. Same number.