Text and number

[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

 

[Frank Kabel]

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

 

[Paul]

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

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