View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Jacob Skaria Jacob Skaria is offline
external usenet poster
 
Posts: 8,520
Default 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