Convert numbers into text (one thousand two hundred)

M

motasim

I would appreciate any assistance in this regard, I would
like to word numbers inside my excel sheet
 
N

Norman Harker

Hi Motasim!

If you want numbers to be translated in Thai then there’s an Excel
function BAHTTEXT that will do it. For some reason Microsoft didn’t
think non-Thai speakers needed an equivalent. So:

See:

XL2000: How to Convert a Numeric Value into English Words
http://support.microsoft.com/default.aspx?scid=KB;EN-US;213360

and:

XL: How to Convert a Numeric Value into English Words
http://support.microsoft.com/default.aspx?scid=KB;EN-US;140704&

and:

(courtesy of a cut and paste from a Tom Ogilvy post):

If you want an addin that provides a worksheet function that does
this,
download Laurent Longre's free morefunc.xll addin found here:

http://longre.free.fr/english/

It is downloaded in a zip file which also contains an informative file
in
'hlp' format that describes the 33 or so very useful functions
included, one
of which does the number to words conversion you describe (supports
various
languages and currencies).

See also Laurent’s latest version that is multi-lingual.

http://longre.free.fr/tradnombre/NbText.zip

and:
(Courtesy of Andy Wiggins FCCA) of www.BygSoftware.com

This file might be a help:
http://www.bygsoftware.com/examples/zipfiles/num2wrds.zip

It's in the "Accountants" section on page:
http://www.bygsoftware.com/examples/examples.htm
It contains two methods to convert numbers to words and two check
writing
routines.

The code is open and commented.

And:

http://groups.google.com/[email protected]
A post containing a UDF by Bernie Deitrick that will take you into US
budget
territory by covering amounts into trillions.

And:
Orlando Magalhaes Filho (MVP)
http://cpap.com.br/orlando/#SpellNumber

A very flexible spell number function that allows, ordinary,
percentage and currency options.
 
N

Norman Harker

Hi Motasim!

You have a bit of a choice there. The MS ones are not generally
favoured but you might get some tips from comparing the coding if you
are into VBA.
 
Top