Y Yot New Member Jan 4, 2011 #1 How do I convert any number (in words) to its number equivalent, and vice versa like in the following examples? 1. one thousand to 1000 2. 1000 to one thousand Is there an Excel formula for this?
How do I convert any number (in words) to its number equivalent, and vice versa like in the following examples? 1. one thousand to 1000 2. 1000 to one thousand Is there an Excel formula for this?
Hui Excel Ninja Staff member Jan 4, 2011 #2 Yot No2. Numbers to Words, have a look at: http://support.microsoft.com/kb/213360 I've never seen anyone do the other way Words to Numbers.
Yot No2. Numbers to Words, have a look at: http://support.microsoft.com/kb/213360 I've never seen anyone do the other way Words to Numbers.
Y Yot New Member Jan 5, 2011 #3 Hui Thank you very much. It really helped, though I need to make some changes like changing the units from dollars to pesos. It's amazing!
Hui Thank you very much. It really helped, though I need to make some changes like changing the units from dollars to pesos. It's amazing!
