View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Stefi Stefi is offline
external usenet poster
 
Posts: 2,646
Default 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