Convert number to words in excel
Closed
arunraaj
Posts
2
Registration date
Thursday 15 February 2018
Status
Member
Last seen
16 February 2018
-
Updated on Feb 15, 2018 at 03:44 AM
TrowaD Posts 2921 Registration date Sunday 12 September 2010 Status Contributor Last seen 27 December 2022 - 22 Feb 2018 à 11:04
TrowaD Posts 2921 Registration date Sunday 12 September 2010 Status Contributor Last seen 27 December 2022 - 22 Feb 2018 à 11:04
Related:
- How to convert number in words in excel
- Convert number to words in excel - Guide
- How to convert number into words in ms word in shortcut key - Guide
- How to clear formatting in excel - Guide
- How to change date format in excel - Guide
- Arrow keys not working in excel - Guide
2 responses
TrowaD
Posts
2921
Registration date
Sunday 12 September 2010
Status
Contributor
Last seen
27 December 2022
555
22 Feb 2018 à 11:04
22 Feb 2018 à 11:04
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 12 September 2010
Status
Contributor
Last seen
27 December 2022
555
15 Feb 2018 à 11:42
15 Feb 2018 à 11:42
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 15 February 2018
Status
Member
Last seen
16 February 2018
16 Feb 2018 à 00:21
16 Feb 2018 à 00:21
i don't want above type answer, i want, like "112" then "one one two", "450" then "four five zero".