| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
convert numercials into words
Hi
I need to learn the formula by which, I Excel converts numerical figures into words automatically. For e.g, In Cell A4, has numerical figure of 4000/- & i need excel to change & display this figures into word ( Four Thousand ) automatically. Pls advise the formula to do so ? Awaiting |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
convert numercials into words
Younus, have a look here for ways to do it
http://www.xldynamic.com/source/xld.xlFAQ0004.html -- Paul B Always backup your data before trying something new Please post any response to the newsgroups so others can benefit from it Feedback on answers is always appreciated! Using Excel 2002 & 2003 "Younus Khatri" <Younus wrote in message ... Hi I need to learn the formula by which, I Excel converts numerical figures into words automatically. For e.g, In Cell A4, has numerical figure of 4000/- & i need excel to change & display this figures into word ( Four Thousand ) automatically. Pls advise the formula to do so ? Awaiting |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how do i convert numbers in figures into words? | Excel Discussion (Misc queries) | |||
| how to automatically convert a number to words in Excel | Excel Worksheet Functions | |||
| I wish excel to convert number to words ie 23 to twenty three | Excel Discussion (Misc queries) | |||
| how do i convert figures into words in excel? | Excel Discussion (Misc queries) | |||
| can excel convert number into words (like 10 to ten)? | Excel Worksheet Functions | |||
Linear Mode
