View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Mike_Gator14 Mike_Gator14 is offline
external usenet poster
 
Posts: 1
Default Numberformat vs string question

Hi,

if I have the following formula on a sheet in cell B1:

If(A10;"Premium due = EUR " & A1;"Premium Return = EUR " & A1)

the return in cell B1 will be f.i. Premium due = EUR 1000

How can I get to print another number format/lay out within the
formula, i.e. that the outcome will be:

Premium due = EUR 1.000,00

Thanks, Mike