Numbers to Text - 25 - Twenty Five

Hi,

I have Numbers in first column which I need to convert to Text in the second column.

Eg.

123 to be converted to Hundred and Twenty Three

Can this be done?

Thanks very much

Originally Posted by sachinattri

Hi,

I have Numbers in first column which I need to convert to Text in the second column.

Eg.

123 to be converted to Hundred and Twenty Three

Can this be done?

Thanks very much

Hi
see the article below from Microsoft web

http://support.microsoft.com/kb/213360

Thanks very much helps. but I want only Numbers and no 'dollars/cents'.

Although I can replace all the dollars/cents with a blank space and get what I want but is there a way I can do it directly? Also as per Lakh and Crore system of India?

thank you very much once again

Good morning sachinattri

Also as per Lakh and Crore system of India?

Unfortunately, I'm not familiar with those conventions.
Do my replies to this thread assist?

http://www.excelforum.com/showthread.php?t=600895

HTH

DominicB