After a few hours of head scratching I cracked the puzzle. Click the Save button disk icon and then go back to your spreadsheet window. You can also manually type the value like SpellNumber 2250.
Azeem143 Hi I modified the formula because the formula length became too long so I had to use a helper cell in column c for splitting the formula into half and then use C1 into the B1 formula as a reference.
Convert text to number with a formula. It will work just like any other worksheet function. In the example shown the formula in C5 is. You can also manually type the value like SpellNumber 2250.