Question: what is the formula in excel for amount in words?
Answer: Use the SpellNumber function in individual cells Type the formula =SpellNumber(A1) into the cell where you want to display a written number, where A1 is the cell containing the number you want to convert. Press Enter to confirm the formula.