Convert number to words in excel
Closed
arunraaj
Posts
2
Registration date
Thursday February 15, 2018
Status
Member
Last seen
February 16, 2018
-
Updated on Feb 15, 2018 at 03:44 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - Feb 22, 2018 at 11:04 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - Feb 22, 2018 at 11:04 AM
Related:
- Convert number to words in excel
- Convert number to words in excel - Guide
- How to convert number to words in word - Guide
- Convert m3u to mp3 - Guide
- Convert picture to shape powerpoint - Guide
- Convert dts to ac3 mkvtoolnix - Guide
2 responses
TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
December 27, 2022
555
Feb 22, 2018 at 11:04 AM
Feb 22, 2018 at 11:04 AM
Hi Arunraaj,
Well, it was suppose to guide you.
Here is a modified version:
Best regards,
Trowa
Well, it was suppose to guide you.
Here is a modified version:
Function NumbersToWord(ByVal MyNumber) Dim x As Integer Dim Result As String For x = 1 To Len(MyNumber) Result = Result & GetDigit(Mid(MyNumber, x, 1)) & " " Next x NumbersToWord = Result End Function Function GetDigit(Digit) Select Case Val(Digit) Case 0: GetDigit = "Zero" Case 1: GetDigit = "One" Case 2: GetDigit = "Two" Case 3: GetDigit = "Three" Case 4: GetDigit = "Four" Case 5: GetDigit = "Five" Case 6: GetDigit = "Six" Case 7: GetDigit = "Seven" Case 8: GetDigit = "Eight" Case 9: GetDigit = "Nine" End Select End Function
Best regards,
Trowa
TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
December 27, 2022
555
Feb 15, 2018 at 11:42 AM
Feb 15, 2018 at 11:42 AM
Hi Arunraaj,
May the following link guide you to your solution:
https://support.microsoft.com/nl-nl/office/getallen-converteren-naar-woorden-a0d166fb-e1ea-4090-95c8-69442cd55d98?ui=nl-nl&rs=nl-nl&ad=nl
Best regards,
Trowa
May the following link guide you to your solution:
https://support.microsoft.com/nl-nl/office/getallen-converteren-naar-woorden-a0d166fb-e1ea-4090-95c8-69442cd55d98?ui=nl-nl&rs=nl-nl&ad=nl
Best regards,
Trowa
arunraaj
Posts
2
Registration date
Thursday February 15, 2018
Status
Member
Last seen
February 16, 2018
Feb 16, 2018 at 12:21 AM
Feb 16, 2018 at 12:21 AM
i don't want above type answer, i want, like "112" then "one one two", "450" then "four five zero".