| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Is their any Function to convert no. in figure to in words
|
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Is their any Function to convert no. in figure to in words
There's no built in function to do that, although you could download the free MOREFUNC addin and use the NBTEXT function, otherwise you need VBA http://xcell05.free.fr/ -- daddylonglegs ------------------------------------------------------------------------ daddylonglegs's Profile: http://www.excelforum.com/member.php...o&userid=30486 View this thread: http://www.excelforum.com/showthread...hreadid=508478 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Is their any Function to convert no. in figure to in words
it is pretty easy to write a function to convert a number into words. such as 12345 into one two three four five. And only a little more complex to get 12 thousand three hundred and fourty five. You do need to know which you want also some sort of maximum: millions, milliards, billions etc. (Or if you are american you skip the milliards and go straight to billions) regards -- tony h ------------------------------------------------------------------------ tony h's Profile: http://www.excelforum.com/member.php...o&userid=21074 View this thread: http://www.excelforum.com/showthread...hreadid=508478 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Function or formula to convert "text" month to number of month? | Excel Discussion (Misc queries) | |||
| Function or formula to convert "text" month to number of month? | Excel Discussion (Misc queries) | |||
| Function or formula to convert "text" month to number of month | Excel Discussion (Misc queries) | |||
| clock | Excel Worksheet Functions | |||
| Convert to Lower case (not with a function) | Excel Worksheet Functions | |||
Hybrid Mode
