Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
WHEN ENTER NUMBER , DISPLAY IN WARDS ?
how can we get in words , when enter number that time display in words
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
WHEN ENTER NUMBER , DISPLAY IN WARDS ?
http://tinyurl.com/8n4fz
by Bob Phillips 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' and http://support.microsoft.com/?scid=kb;en-us;259663 'How To Convert Currency or Numbers into English Words' In the latter cases, if you are not familiar with macros, you may wish to visit David McRitchie's 'Getting Started With Macros And User Defined Functions' at: http://www.mvps.org/dmcritchie/excel/getstarted.htm By Norman Jones etc. -- Regards! Stefi €˛numbers in words€¯ ezt Ć*rta: how can we get in words , when enter number that time display in words |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
HOW WE CAN FIT THE TEXT MESSAGES IN SINGLE COLUNM UP/DOWN WARDS | New Users to Excel | |||
Why am I getting ### when I enter an accting number and hit enter | New Users to Excel | |||
Enter number in a cell and it is to display time. | Excel Worksheet Functions | |||
how do I enter a value, display that many fields? | Excel Discussion (Misc queries) | |||
Numbers display as decimal, i.e. enter 123 display 1.23 | Setting up and Configuration of Excel |