Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
can we convert number to text in excel as if 1= One | Excel Discussion (Misc queries) | |||
How do I convert a number in Excel to text? | Excel Worksheet Functions | |||
In Excel, how do we convert text into number (value)? | Excel Worksheet Functions | |||
convert text-format number to number in excel 2000%3f | Excel Discussion (Misc queries) | |||
convert number to text in Excel | Excel Programming |