| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
in excel how can we put formula to convert numericalfigureto word
for example :
in excel i have mention 25000.00 in numerical amount , i want to know how can i convert in next colum , about word ?/; How can i put formula to make the numerical in to words like 25000 in numerical to twenty five thousands in word. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
in excel how can we put formula to convert numericalfigureto word
There is no direct functions to convert this. For a VBA solution check out
the below links http://support.microsoft.com/kb/213360 http://www.ozgrid.com/VBA/ValueToWords.htm http://www.xldynamic.com/source/xld.xlFAQ0004.html -- Jacob (MVP - Excel) "excel" wrote: for example : in excel i have mention 25000.00 in numerical amount , i want to know how can i convert in next colum , about word ?/; How can i put formula to make the numerical in to words like 25000 in numerical to twenty five thousands in word. |
|
#3
|
|||
|
|||
Quote:
try this excel add ins, easy to convert figures to words. http://www.sobolsoft.com/excelnumber/ all the best
__________________
Thanks Bala Last edited by bala_vb : May 7th 10 at 03:47 PM Reason: url added, earlier forgot to paste it in a hurry |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
in excel how can we put formula to convert numericalfigureto word
Hi,
look here http://www.xldynamic.com/source/xld.xlFAQ0004.html "excel" wrote: for example : in excel i have mention 25000.00 in numerical amount , i want to know how can i convert in next colum , about word ?/; How can i put formula to make the numerical in to words like 25000 in numerical to twenty five thousands in word. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| number convert to word in excel which formula | Excel Discussion (Misc queries) | |||
| convert excel to word | Excel Discussion (Misc queries) | |||
| Convert Word to excel | Excel Discussion (Misc queries) | |||
| convert a Word doc into an Excel doc. | Excel Discussion (Misc queries) | |||
| convert word doc to excel | Excel Discussion (Misc queries) | |||
Hybrid Mode
