View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Sanjay Sanjay is offline
external usenet poster
 
Posts: 31
Default convert a numeric number in text format in another cell?

Dear Manju,

Thanks for the link
how to change dollar to rupees.

Regards
Sanjay

"Manju" wrote:

Please follow this link
http://www.xldynamic.com/source/xld.xlFAQ0004.html
http://www.j-walk.com/ss/excel/usertips/tip002.htm

Abhishek wrote:
HI,

while using ms excel 2003 i am unable to convert any numeric number in text
fromat in another cell or worksheet. what i want to do, that can be explained
as follows: " in cell a1 i typed Rs. 1000" and i want this figure to
converted in cell c45 as " Rupees one thousnad". could you please help me out
on this and the same thing as vice versa.

thanks,
abhishek