| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Change number to word
Hi
Im preparing Voucher in spreedsheet, i want to change the number to word format automatically. eg. cell A1 = 2,000.10 cell c1 = Two Thousand and Ten Cents Only can any body help me |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Change number to word
Look here for several solutions:
http://xldynamic.com/source/xld.xlFAQ0004.html -- Kind regards, Niek Otten Microsoft MVP - Excel "Khai" wrote in message ... | Hi | Im preparing Voucher in spreedsheet, i want to change the number to word | format automatically. | | eg. | | cell A1 = 2,000.10 | | cell c1 = Two Thousand and Ten Cents Only | | can any body help me |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Change number to word
Hi,
There are a few sites with code to do this, this is as good as any. http://www.ozgrid.com/VBA/ValueToWords.htm Mike "Khai" wrote: Hi Im preparing Voucher in spreedsheet, i want to change the number to word format automatically. eg. cell A1 = 2,000.10 cell c1 = Two Thousand and Ten Cents Only can any body help me |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Change number to word
Download and install the free add-in Morefunc.xll from:
http://xcell05.free.fr/ then use this formula =NBTEXT(A1)&IF(MOD(A1,1)," Cents","") "Khai" wrote: Hi Im preparing Voucher in spreedsheet, i want to change the number to word format automatically. eg. cell A1 = 2,000.10 cell c1 = Two Thousand and Ten Cents Only can any body help me |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Change number to word
"Khai" wrote: Hi Im preparing Voucher in spreedsheet, i want to change the number to word format automatically. eg. cell A1 = 2,000.10 cell c1 = Two Thousand and Ten Cents Only can any body help me |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formulae or format to change a number "1" into the word "one | Excel Discussion (Misc queries) | |||
| change info in other cells when i change a number in a drop list? | Excel Discussion (Misc queries) | |||
| copy a number typed in a cell to another & change it to word form. | Excel Discussion (Misc queries) | |||
| change a number (100) to word (i.e Hundred) | Excel Discussion (Misc queries) | |||
| Embedded word doc changed to image-need to change back to word. | Excel Discussion (Misc queries) | |||
Linear Mode
