Previous Topic Next Topic

Number to Words

Closed
Report
Posts
1
Registration date
Tuesday June 4, 2013
Status
Member
Last seen
June 4, 2013
 -
Posts
2829
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
November 22, 2021
 -
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
Posts
2829
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
November 22, 2021
 490
https://ccm.net/forum/affich-702345-convertion-number-into-word#p702863
Answer 2 / 2

=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")))))))
Report
Posts
2829
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
November 22, 2021
 490
Nice try Mark, but you will need a whole lot more IF functions if you want to solve it that way.
Report
Blocked Profile
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.
Report
Posts
2829
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
November 22, 2021
 490
Well I have to agree with you too, but I guessed encouragement was all he needed.
Ask a question