In other words it converts a numeric value into English words with currency. SpellNumber is a manually created function through VBA Programming to change a number to written text. This formula is used to convert a number into American currency.
The following example shows a formula in cell D2 that multiplies cells A2 B2 and a discount derived from C2 to calculate an invoice amount for a sale.
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. Using The VALUE Function. It will work just like any other worksheet function.