• 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.

Please help on Spell to number and number to spell

..... are you trying to get something that will allow you to enter a number (6) and it outputs the spelling (Six)?

if so, the only thing i can think of would be to have a list of the numbers and of the spellings. then just use vlookup to find the provied digit or spelling and retrun the digit.
 
I found this, maybe could be useful..... Regards
 

Attachments

  • WordsToDigits.xlsm
    26.3 KB · Views: 7
  • Spell Number 1.xlsm
    24.8 KB · Views: 10
  • Spell Number 2.xlsm
    19.7 KB · Views: 7
Just a few notes on correctly worded numbers:
  • the word "and" is ONLY used to separate the integer and fractional parts of a number
    • RIGHT: 7.3 - seven and three tenths
    • WRONG: 306 - three hundred and six (should be three hundred six)
  • commas go in words in the same places they do in numbers
    • e.g. 5,002,008 - five million, two thousand, eight
  • hyphens are only in the tens numbers unless the number has a ones digit of zero
    • 75 - seventy-five 70 - seventy
    • twenty twenty-something
    • thirty thirty-something
    • ninety ninety-something
That's all the rules I can think of right now. Happy cipherin'!!! (something Jethro Bodine from the Beverly Hillbillies would say)
Anything worth doing is worth doing right correctly ;)
 
Back
Top