want to convert number to word (eg) 1 as one

  • Thread starter Thread starter S.Ramanujam
  • Start date Start date
S

S.Ramanujam

I would like to convert automaticaly the numericals into word format fo
example

In excel If I type 100.00 ( it should type automatically (one hundre
only).

Is it available in excel.

If anyone knows pls reply to my e-mail (e-mail address removed)
 
It is not available by default, but this is an often-asked question in this
forum. You may want to do a search and see if you find your answer.
Otherwise, are you looking for a formula or a VBA macro? If you're looking
to put the text in a different cell from the number, then a formula will
work. If you're looking to replace the number with the text, then you
probably want a macro. If you can't find your answer by doing a search, let
us know which solution you'd prefer, you're sure to get a response.
 
Hi
there're some macros/procedures to convert numbers to text. e.g.
MS Knowledge Base:
http://support.microsoft.com/default.aspx?scid=KB;EN-US;213360
http://support.microsoft.com/default.aspx?scid=KB;EN-US;140704&

Free Addin MOREFUNC-DLL which includes a UDF for this task (for various
languages):
http://longre.free.fr/english/

or have a look at
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
 
Thank you Mr.Trevor for your response. I would like to have simpl
formula type to convert number into text string.

Please help.

regards/s.ramanujam
 
Back
Top