Do you mean putting numbers into words, like 1234 returns One Thousand Two hundred Thirty-Four?
If so, then this monster formula I found online (apologies to the originator - I've lost your name) works well. No VBA.
Paste it into Cell C3. It converts the digits you've entered in Cell B3 into words
Regards - Dave.
Code:
=IF(OR(LEN(FLOOR(B3,1))>=13,FLOOR(B3,1)<=0),"Out of range",PROPER(SUBSTITUTE(CONCATENATE(CHOOSE(MID(TEXT(INT(B3),REPT(0,12)),1,1)+1,"","one
Leave a comment: