| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Say it in words
Hi,
Am doing an invoice in Excel and need to print the value in words. |For example if the total of invoice is $ 100.00, in the next cell it should write " One hundred and cents zero " Is there any formula to get this result ? Thanks -- Cheers ! |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Say it in words
From a post in another newsgroup.
See Bob Phillips' site http://www.xldynamic.com/source/xld.xlFAQ0004.html Gord Dibben MS Excel MVP HTH Regards, Howard "Sena" wrote in message ... Hi, Am doing an invoice in Excel and need to print the value in words. |For example if the total of invoice is $ 100.00, in the next cell it should write " One hundred and cents zero " Is there any formula to get this result ? Thanks -- Cheers ! |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Say it in words
hi
not a "built in" fomula. maybe an UDF. others have had this need too. see these sites. http://www.xldynamic.com/source/xld.xlFAQ0004.html http://www.sulprobil.com/html/spellnumber.html http://support.microsoft.com/?kbid=213360 regards FSt1 "Sena" wrote: Hi, Am doing an invoice in Excel and need to print the value in words. |For example if the total of invoice is $ 100.00, in the next cell it should write " One hundred and cents zero " Is there any formula to get this result ? Thanks -- Cheers ! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| in words | Excel Worksheet Functions | |||
| how to convert numeric to words Example 525 in words (Twenty five | Excel Discussion (Misc queries) | |||
| words | Excel Discussion (Misc queries) | |||
| how do i insert words into a column without erasing the words | Excel Discussion (Misc queries) | |||
| more words | New Users to Excel | |||
Linear Mode
