HOW CONVERT NUMBER IN TEXT IN EXCEL LIKE A INVOICE
 

hello I need to convert a number or a amount to texto like in an invoice, for
the price in text, please if someone know how, helpme!!!

Thank´s

HOW CONVERT NUMBER IN TEXT IN EXCEL LIKE A INVOICE
 

"Javier" wrote in message
...
hello I need to convert a number or a amount to texto like in an invoice,
for
the price in text, please if someone know how, helpme!!!

Thank´s


Excel will automatically convert numbers to text where necessary. However,
if you really need to this kind of conversion, you can call the STR
function. Waht's really the problem? maybe it's enough to format the cells
as text.

/Fredrik

HOW CONVERT NUMBER IN TEXT IN EXCEL LIKE A INVOICE
 

Select the cell
Choose Format
Choose Cells
In the first tab of the 'Format Cells' dialog choose Text

This will convert the way that cell stores value from number (default) to text

"Javier" wrote:

hello I need to convert a number or a amount to texto like in an invoice, for
the price in text, please if someone know how, helpme!!!

Thank´s

HOW CONVERT NUMBER IN TEXT IN EXCEL LIKE A INVOICE
 

Javier,

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

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Javier" wrote in message
...
hello I need to convert a number or a amount to texto like in an invoice,
for
the price in text, please if someone know how, helpme!!!

Thank´s