Spell number in excel

[baidya91]

How can I spell a number like 1-100 in excel: 57 = Fifty Seven?

 

[CA_Punit]

You should see this

Convert numbers into words - Microsoft Support

Discover how to convert numbers into English words in an Excel spreadsheet using the SpellNumber sample function.

support.microsoft.com

 

[baidya91]

This gives syntax error.....

 

[CA_Punit]

Is option Explicit turned on in VBA??? I dont know much about VBA. I also encountered same syntax error

 

[Sulprobil]

There are many erroneous versions circulating in the web.
I suggest to google for sbSpellNumber.