Change a Number to Text

[suryatry26]

Here how to convert Number to Text..Like 100 means One Hundred.For this any formula is there? i want to change Full A Column numbers to Text..Number To Text.jpg

[Fotis1991]

You'll find a way to do this, here.

http://www.meadinkent.co.uk/xlnumberstext.htm

[suryatry26]

Hi Fotis i got it..But i dont know how to use that macro..I tried there no change in my excel.can you tell how to use? or there is any cell range fixed?