=TEXT(A1,"0%")&B1

as an example

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"
wrote in message
...
In my formula I copied a cell that was formatted with a percentage. When
I
finished the concatenate formula the cell that was input was in a decimal
format. How do I keep the format of the cell when linking it to the
concatenate formula?