Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How convert Numeric number in words
Is there any easy formula or way to convert numeric values in words? For
example in cell A1 there is an amount 19549. How could it will be automaticaly converted by a formula in cell B1 as Ninteen thousand five hundred and forty-nine. Please give me an easy answer because i am not a programmer but just an excel user. Imran Murtaza |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How convert Numeric number in words
There is no direct function to convert this. For a VBA solution check out the
below links http://www.ozgrid.com/VBA/ValueToWords.htm http://support.microsoft.com/kb/213360 http://www.xldynamic.com/source/xld.xlFAQ0004.html -- Jacob "Imran Murtaza" wrote: Is there any easy formula or way to convert numeric values in words? For example in cell A1 there is an amount 19549. How could it will be automaticaly converted by a formula in cell B1 as Ninteen thousand five hundred and forty-nine. Please give me an easy answer because i am not a programmer but just an excel user. Imran Murtaza |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How convert Numeric number in words
Hi,
You might consider installing the excellent addin MOREFUNC You can get it by Googling but here's as good a place as any http://download.cnet.com/Morefunc/30...-10423159.html When installed you get a library of functions including =NBTEXT(A1) Which converts numbers to words -- Mike When competing hypotheses are otherwise equal, adopt the hypothesis that introduces the fewest assumptions while still sufficiently answering the question. "Imran Murtaza" wrote: Is there any easy formula or way to convert numeric values in words? For example in cell A1 there is an amount 19549. How could it will be automaticaly converted by a formula in cell B1 as Ninteen thousand five hundred and forty-nine. Please give me an easy answer because i am not a programmer but just an excel user. Imran Murtaza |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to convert a numeric value into words | Excel Discussion (Misc queries) | |||
how to convert numeric to words Example 525 in words (Twenty five | Excel Discussion (Misc queries) | |||
Is it possible to convert numeric figures in to words like (1,200. | Excel Worksheet Functions | |||
how to convert numeric into words | New Users to Excel | |||
how do I convert numeric data to words? | Excel Discussion (Misc queries) |