• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Converting text to numbers and vice versa

Yot

New Member
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?
 
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.
 
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!
 
Back
Top