HOW CAN I CONVERT NUMBERS INTO TEXT IN A PARTICULAR CELL.

[Jaya]

IS THERE ANY FUNCTION IN EXCEL, WHICH CONVERT TO NUMBER INTO TEXT. IN A
PARTICULAR CELL. FOR EXAMPLE NUMBER 100 INTO "ONE HUNDRED"

[dominicb]

Good morning Jaya

There isn't a built in Excel formula for it, but Microsoft have provided a function to do it. You can download it from here.

http://www.barasch.com/excel/cCo11432.htm

HTH

DominicB

[Andy Brown]

"Jaya" <[email protected]> wrote in message
news:[email protected]...
> IS THERE ANY FUNCTION IN EXCEL, WHICH CONVERT TO NUMBER INTO TEXT. IN A
> PARTICULAR CELL. FOR EXAMPLE NUMBER 100 INTO "ONE HUNDRED"

There's no built-in function AFAIK. Try the custom function @

http://support.microsoft.com/default...b;en-us;213360

Rgds,
Andy

[cycling-rod]

If the English UK Pounds, Pence are required rather than Dollars and Cents, then both the examples posted by Andy and dominicb, will need to be changed. Copy the code and paste into Notebook. Use Find and Replace: Dollars in Find and Pounds in Replace, Replace All. Also do Dollar and Cent (singular) replacing with Pound and Pence. Then, after a visual check, select all and Copy and Paste the code into a Macro.