Forum Discussion
Excel Crashes When Applying Formula
Hi, new to using forums and also pretty fresh to excel but I'm looking for some advice/a solution. I recently undertook a project designing a tool inventory for the company I'm working for and am ha...
Without having tried the formula it could be the addition.
Although numbers can be concatenated, Excel does not consider the result as a number, but as text. Therefore, the result shown cannot be used as an argument for certain mathematical functions such as SUM and AVERAGE. When this type of input is included in a function's arguments, it is treated like other text data and is ignored.
You can combine up to 255 text arguments at once.
Maybe this information can help you...if not please just ignore it :).
I know I don't know anything (Socrates)