I just want to know that if I enter some value like "1000"
it can b change into text form like "one thousand"
if there is any formula *** tell me
this is my mailing address >Removed<
![]() |
I just want to know that if I enter some value like "1000"
it can b change into text form like "one thousand"
if there is any formula *** tell me
this is my mailing address >Removed<
No there is no built-in Excel function to convert numbers to word-text. You can add that functionality in.
Here's a page that offers a User-Defined-Function call SpellNumber that you can install into your workbook and use.
Excel: Convert Numbers to Words/Text
If you Google: converting excel numbers to text you'll tons more just like it. This isn't an uncommon desire.
All times are GMT -7. The time now is 03:38 AM. |