Prev: Deleting Style 1 not found
Next: Columns
From: excel excel on 7 May 2010 02:41
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.
From: Jacob Skaria on 7 May 2010 02:55
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.
From: Eduardo on 7 May 2010 06:43
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.
 | 
Pages: 1
Prev: Deleting Style 1 not found
Next: Columns