NUMERIC TO TEXT IN EXCEL 2007

This query is : Resolved

Anil Chauhan (Querist)
Follow

07 March 2011 PLEST TELL ME HOW CONVERT NUMERIC TO TEXT IN EXCEL 2007

FOR EXAMPLE - 1234/-
CONVERT IN TO WITH FORMULA- RUPEES ONE THOUSAND TWO HUNDRED THIRTY FOUR ONLY.

Ashish

Ashish (Expert)
Follow

08 March 2011 Here is something that I found to be the quickest. Download free version of asap utilities (search on google). After installing you will see a ribbon in Excel 2007. In that in the dropdown menu of Numbers the 9t Item can convert your selection of numbers to the text that you desire.

After this you would need to add "only at the end which you can do easily.

Hope this helps