| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do i create formula in words from amounts
In 1 cell i have amount 3,400.00. how do i create a formula in another cell
for amount in words? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do i create formula in words from amounts
hi
see this site http://support.microsoft.com/?kbid=213360 regards FSt1 "Komal" wrote: In 1 cell i have amount 3,400.00. how do i create a formula in another cell for amount in words? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do i create formula in words from amounts
Check out the NBTEXT function in Laurent Longre's free MoreFunc addin, which
you can download: http://xcell05.free.fr/ There are also some Microsoft articles you could check out: http://support.microsoft.com/default...b;en-us;213360 'How to convert a numeric value into English words in Excel' http://support.microsoft.com/?scid=kb;en-us;259663 'How To Convert Currency or Numbers into English Words' If you are new to macros, this link to Jon Peltier's site may be helpful: http://peltiertech.com/WordPress/200...e-elses-macro/ Hope this helps, Hutch "Komal" wrote: In 1 cell i have amount 3,400.00. how do i create a formula in another cell for amount in words? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Create a key that converts numbers to words? | Excel Discussion (Misc queries) | |||
| Amounts as words | Excel Discussion (Misc queries) | |||
| How do I convert Amounts written in figures to words ? | Excel Discussion (Misc queries) | |||
| 11 $ amounts, 6 of the amounts must equal $3854.12, which 6? | Excel Discussion (Misc queries) | |||
| how to create refrence using first and last words of any supplier | Excel Worksheet Functions | |||
Hybrid Mode
