Please help on Spell to number and number to spell

[bhasoriya]

Hello Friends,
I have checked the below given link
http://chandoo.org/forum/threads/how-convert-number-to-text-in-excel.12009/

I get the nearest result. But actually i wants to teach my boy. I don't want "Rupees only" or"Paisa" at last..
and
If Possible I would also like to convert Spell to number.

Could you please guide me. how to do..?
I have used "Spellnumber.xlsx" file.

Thanks in Advance.

 

[json]

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

 

[azumi]

I found this, maybe could be useful..... Regards

 

[bhasoriya]

Hello Azumi,

Thanks a lot.. It is exactly that what i want..
Thank you.

 

[XLPadawan]

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