How to convert digits to word in Excel


#1

Hello,

I am trying to convert digits like “456” into four fifty six. so can anyone help me this regard.

Regards


#2

You’ll need to create a loop using logic such as this :slight_smile:

Effectively split the “456” string into characters then for each character determine what the equivalent word is. There may be an easier way than this- doesn’t seem particularly efficient.

RD