Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to convert amount in word format (Like 40.00 is Rs. Forty )
I want to convert a value of cell in word format,
Like i have a value in cell is 40000.00 (i want to convert it into Rs. Forty Thousand Only) is there any formula in excel for this function |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to convert amount in word format (Like 40.00 is Rs. Forty )
See http://www.xldynamic.com/source/xld.xlFAQ0004.html
-- HTH Bob Phillips (remove nothere from email address if mailing direct) "Dinesh" wrote in message ... I want to convert a value of cell in word format, Like i have a value in cell is 40000.00 (i want to convert it into Rs. Forty Thousand Only) is there any formula in excel for this function |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to convert amount in word format (Like 40.00 is Rs. Forty )
Yes, see: How to Convert a Numeric Value into English Words http://support.microsoft.com/default...EN-US;Q213360& -- Gary's Student "Dinesh" wrote: I want to convert a value of cell in word format, Like i have a value in cell is 40000.00 (i want to convert it into Rs. Forty Thousand Only) is there any formula in excel for this function |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Date format not correct when you convert a CSV text file in Excel | Excel Discussion (Misc queries) | |||
How to convert number in word format like (1000 i.e. One Thousand | Excel Discussion (Misc queries) | |||
Convert [h]:mm sum total format to number format | Excel Worksheet Functions | |||
Excel format changes as I merge into Word document How can I stop | Excel Discussion (Misc queries) | |||
How to convert the table in word to excel sheet? | Excel Discussion (Misc queries) |