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 |