| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
convert a numeric number in text format in another cell?
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
convert a numeric number in text format in another cell?
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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to convert a month to a quarter ...... | New Users to Excel | |||
| Convert numbers from text format to number format | Excel Discussion (Misc queries) | |||
| Can I convert numeric 0510 to time 05:10 by custom cell format? | Excel Discussion (Misc queries) | |||
| Return SEARCHED Column Number of Numeric Label and Value | Excel Worksheet Functions | |||
| Changing cell format - for example text to numeric | Excel Discussion (Misc queries) | |||
Linear Mode
