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
2886
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
June 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 replies

Answer 1 / 2
TrowaD
Posts
2886
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
June 27, 2022
 515
Jun 4, 2013 at 11:09 AM
https://ccm.net/forum/affich-702345-convertion-number-into-word#p702863
0
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")))))))
0
TrowaD
Posts
2886
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
June 27, 2022
 515
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.
0
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.
0
TrowaD
Posts
2886
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
June 27, 2022
 515
Jun 10, 2013 at 10:22 AM
Well I have to agree with you too, but I guessed encouragement was all he needed.
0