View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Fredrik Wahlgren Fredrik Wahlgren is offline
external usenet poster
 
Posts: 339
Default 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