Menu
  1. Accueil
  2. Tech Forum
  3. Office Software
  4. Excel

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

Answer 1 / 2
Posts
2742
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
May 4, 2021
 460
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
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.
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
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.
Ask a question

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!