Number to Words [Closed]

Report
Posts
1
Registration date
Tuesday June 4, 2013
Status
Member
Last seen
June 4, 2013
-
Posts
2742
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
May 4, 2021
-
Dear Kioskes,

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

could please replay me

2 replies

Posts
2742
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
May 4, 2021
460

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

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!