Previous Topic Next Topic

Number to Words

Closed
syed abdulrahman Posts 1 Registration date Tuesday June 4, 2013 Status Member Last seen June 4, 2013 - Jun 4, 2013 at 10:20 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - Jun 10, 2013 at 10:22 AM
Dear Kioskes,

Ex: 45,450.55, Forty five thousand four hundred and fifty & 55/100 only

could please replay me

2 responses

Answer 1 / 2
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 555
Jun 4, 2013 at 11:09 AM
https://ccm.net/forum/affich-702345-convertion-number-into-word#p702863
Answer 2 / 2
Blocked Profile
Jun 4, 2013 at 02:32 PM
=IF(LEFT(I23,1)="9","NINE",IF(LEFT(I23,1)="8","EIGHT",IF(LEFT(I23,1)="7","SEVEN",IF(LEFT(I23,1)="6","SIX",IF(LEFT(I23,1)="5","FIVE",IF(LEFT(I23,1)="4","FOUR",IF(LEFT(I23,1)="3","THREE")))))))
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 555
Jun 6, 2013 at 10:41 AM
Nice try Mark, but you will need a whole lot more IF functions if you want to solve it that way.
Blocked Profile
Jun 6, 2013 at 12:06 PM
yep, i agree. This is how I do it spanned over 6 cells, as seperated and distrubuted frm primary cell to 6 seperate cells.

I am not certain of the link that have given here, no answer just an encouragement to search harder.
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 555
Jun 10, 2013 at 10:22 AM
Well I have to agree with you too, but I guessed encouragement was all he needed.