Forum Discussion
Varun07
May 05, 2020Copper Contributor
Text into words
I am trying to convert number into words in different cell. For example, i have 30 written in A1 and I want this to be written as THIRTY in B5. I tried pasting the formula in module under VB but tha...
jaymaradiaga
May 09, 2020Iron Contributor
Hi Varun07
You can try with a macro, check this link: https://support.office.com/en-us/article/convert-numbers-into-words-a0d166fb-e1ea-4090-95c8-69442cd55d98
Also you can check this video if you prefer a formula: https://www.youtube.com/watch?v=1HVLSuAZEtQ
Hope this helps.
JM