| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to change the year digit? | Excel Discussion (Misc queries) | |||
| Change 18-digit dec number to hex | Excel Worksheet Functions | |||
| change a list of 2 digit years to 4 digit years? | Excel Worksheet Functions | |||
| change first 2 digit ignore the other 2. | Excel Worksheet Functions | |||
| Change second digit from 4 to 6 | Excel Worksheet Functions | |||
Linear Mode
