Convert number to word in excel

Closed
Indronil - 31 Mar 2016 à 08:33
Ambucias Posts 47312 Registration date Monday 1 February 2010 Status Moderator Last seen 28 March 2026 - 31 Mar 2016 à 16:15
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.
Related:

2 responses

Ambucias Posts 47312 Registration date Monday 1 February 2010 Status Moderator Last seen 28 March 2026 11,166
31 Mar 2016 à 16:15
Hello

Your solution is here in this CCM How-to:

https://ccm.net/faq/19271-how-to-convert-numbers-to-words-in-excel
JONDZ Posts 52 Registration date Tuesday 9 February 2016 Status Member Last seen 18 July 2016 6
31 Mar 2016 à 09:29
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.