Num in to word

[DATTATREYA]

Hi,

could you pls help wen enter Num in xl sheet its automatically show word too.(Code or formula)

Ex: 1983 - One Thousand Nine Houndered Eithty Three


Thanx in advance,
Dattatreya.U

 

[VoG]

See if this helps http://www.meadinkent.co.uk/xlnumberstext.htm

 

[DATTATREYA]

Mr. Vog Thanx ton working fine