changing number to text

[lezawang]

Hi
Is it possible to change number to text. For example if I type 1,3,5, etc. I want excel to display them like One, Three, Five etc. Is that possible with Number formatting or any other way?
Thanks a lot.

 

[S.H.A.D.O.]

I think you will probably have to setup a user defined function for this!

 

[dmt32]

As already mentioned, a UDF likely to be required.

have look here:https://support.microsoft.com/en-us...t-a-numeric-value-into-english-words-in-excel

and see if any help

Dave