Convert number to word in excel

Closed
Indronil - Mar 31, 2016 at 08:33 AM
Ambucias Posts 47310 Registration date Monday February 1, 2010 Status Moderator Last seen February 15, 2023 - Mar 31, 2016 at 04:15 PM
Hello,

I want to write number but dont want to spell the the same in word please suggest the formula to convert the same.

Ex:-6000 Six Thousand.

2 responses

Ambucias Posts 47310 Registration date Monday February 1, 2010 Status Moderator Last seen February 15, 2023 11,165
Mar 31, 2016 at 04:15 PM
Hello

Your solution is here in this CCM How-to:

https://ccm.net/faq/19271-how-to-convert-numbers-to-words-in-excel
1
JONDZ Posts 52 Registration date Tuesday February 9, 2016 Status Member Last seen July 18, 2016 6
Mar 31, 2016 at 09:29 AM
Hi,

Normally, excel does not contain any built in function that will convert a number into words, but if you search in Google you can find several user defined functions to perform this task.

For example, a user defined function called WordNum(value) will accept almost any number value and convert it into a long string of words in written English.
0