HOW CONVERT NUMBER IN TEXT IN EXCEL LIKE A INVOICE

[Guest]

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

 

[Fredrik Wahlgren]

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

 

[Guest]

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

 

[Bob Phillips]

Javier,

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

--

HTH

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