Insert Characters into Cell

[electrofunk]

Hi There

I need to insert the " % " character into a cell at the beginning and end of the data within it.

Cell A1 Currently looks like this: 12345
I need cell B1 to look like this: %12345%

Anyone know a formula?
Thanks in advance!
Much appreciated

 

[Scott Huish]

="%" & A1 & "%"

 

[scwyj]

select cell B1, go to Format>cells

On the Number tab, select "Custom" then type in the Type box the following

%#####%

Click ok

Now in cell B1, enter this formula

=A1/10000

Copy the formula down the column.

Scwyjjy

 

[Scott Huish]

If you're going to use a Number Format to do it (note the % signs will not actually be part of the cell value, just displayed that way), you don't need the dividing by 10000 part.

=A1

Format as \%0\%