On Sat, 11 Nov 2006 18:35:01 -0800, Gerardo Granados
wrote:

Thank you, by I need to convert numbers into text in Spanish.

"Gord Dibben" wrote:

See Bob Phillips' site.

http://www.xldynamic.com/source/xld.xlFAQ0004.html


Gord Dibben MS Excel MVP

On Sat, 11 Nov 2006 17:08:02 -0800, Gerardo Granados <Gerardo
wrote:




Download and install Longre's free morefunc.xll add-in from
http://xcell05.free.fr/

Then use the NBTEXT function.

As an example:

A1: 1234,56

=NBTEXT(A1,4)

-- Mil doscientos treinta y cuatro, cincuenta y seis


But there are a number of possible variations, including specifying currency.

I don't know the Spanish words, but a variation using English:

=NBTEXT(A1,,,"and","and","hundredth","hundredths")

One thousand two hundred thirty-four and fifty-six hundredths

Lots of flexibility.
--ron