How do you spell automatically for an amount in Excel format?

Answer 1

If you mean to change numbers into the word equivalents, like 7 into seven, that cannot be done. Even though we only have 10 digits, there are an infinite amount of numbers with all sorts of names, so it is not possible to do it for all numbers. You could do it for a small range, say 1 to 20, but to do it for all numbers is not practical.

To do it for 1 to 20, you could do it as follows. In A1 type in the word "Number" and in the cells from A2 to A21 type the numbers 1 to 20. Then in B1 type in "Words" and in B2 to B21 type the corresponding words to the numbers beside them.

Then in A25 type a number. In B25 enter the following formula:

=VLOOKUP(A25,A2:B21,2)

Now any time you type a number between 1 and 20 into A25, B25 will show the word for it. If you then think of having to do that for more numbers, you can see how impractical it would be. Even this will only work for numbers put into A25, not any other cell. So for many reasons, it could not be done.