How do i change a digit into word i,e 1 = one
 

Hello!

It is Hari Krishna, RAIPUR when ever i using the Excel it is probleamitic
for me do a single work two times, first i write a digit then in words like
100 then in words like one hundred so, i want to minimise my work. pls help

How do i change a digit into word i,e 1 = one
 

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


"HARI KRISHNA" wrote:

Hello!

It is Hari Krishna, RAIPUR when ever i using the Excel it is probleamitic
for me do a single work two times, first i write a digit then in words like
100 then in words like one hundred so, i want to minimise my work. pls help