| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How do I see the amount in words (I will enter amount in numbers)
Hi all, I am entering the amount in dollars (Eg. $ 500) and I want to see in the next cell the amount in words i.e. Dollars Five Hundred. what formula I have to use to see the amount in words. any help is appreciable |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How do I see the amount in words (I will enter amount in numbers)
Hi,
From a previous posting by "DavesExcel": You could download Laurent Longre's MoreFunc addin which is freely downloadable at: http://xcell05.free.fr/ The addin includes the NBTEXT function which converts a positive number into spelled-out text (supports 13 languages). Also see: http://support.microsoft.com/default...b;en-us;213360 'How to convert a numeric value into English words in Excel' HTH "Ram" wrote: Hi all, I am entering the amount in dollars (Eg. $ 500) and I want to see in the next cell the amount in words i.e. Dollars Five Hundred. what formula I have to use to see the amount in words. any help is appreciable |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| what is the formula for returning the amount to amount in words | Excel Discussion (Misc queries) | |||
| How to change amount in figure to amount in words? | Excel Worksheet Functions | |||
| how to convert the amount in currency into the amount in words? | Excel Discussion (Misc queries) | |||
| Converting amount in figures to amount in words | Excel Discussion (Misc queries) | |||
| Amount or Numbers in Words | New Users to Excel | |||
Hybrid Mode
