Text and number

  • Thread starter Thread starter Manos
  • Start date Start date
M

Manos

Dear all
with teh following formula i have a text and then the
number
="Euro"&TEXT(a1+b1, "0.000")

who can i make to have first the number and then the text,
or have text before and after the number?

Thanks in avdance
Manos
 
Hi Manos
one way:
=TEXT(a1+b1, "0.000") & "Euro"
but I would consider using a fomat for this. Just enter =a1+b1 in the
target cell and format this cell (goto 'Format - cells' and choose
currency or customer format. E.g. the custom format
#.##0,00 "Euro"
will add the text 'Euro' after the number
or
"Euro" #.##0,00 "Euro"
will add the text 'Euro' at the beginning and end of your number

This way you can calculate with the result. The first solution will not
allow any calculations

HTH
Frank
 
Manos said:
Dear all
with teh following formula i have a text and then the
number
="Euro"&TEXT(a1+b1, "0.000")

who can i make to have first the number and then the text,
or have text before and after the number?

Thanks in avdance
Manos
Click to expand...

=TEXT(a1+b1, "0.000")&"Euro"
="Euro"&TEXT(a1+b1, "0.000")&"more text"
 
Back
Top