| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I convert number into full text amount
I want to use Excel to print cheque, I want to know if I can convert the
number into text amount, e.g. 500 convert into Five Hundred. Thanks and regards |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I convert number into full text amount
See Bob Phillips' site for methods.
http://www.xldynamic.com/source/xld.xlFAQ0004.html Gord Dibben MS Excel MVP On Sat, 28 Apr 2007 11:10:01 -0700, HONG KONG CHE <HONG KONG wrote: I want to use Excel to print cheque, I want to know if I can convert the number into text amount, e.g. 500 convert into Five Hundred. Thanks and regards |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how to convert the amount in currency into the amount in words? | Excel Discussion (Misc queries) | |||
| how do write the amount of a number in text? | Excel Worksheet Functions | |||
| convert text-format number to number in excel 2000%3f | Excel Discussion (Misc queries) | |||
| How to convert a hyperlink to its target full-text URL | Excel Discussion (Misc queries) | |||
| not able to convert text, or graphic number to regular number in e | Excel Worksheet Functions | |||
Linear Mode
