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.

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.

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.

try this excel add ins, easy to convert figures to words.

http://www.sobolsoft.com/excelnumber/

all the best