putting symbols

[Guest]

i what to put *in front and behind the numbers in colunm A. my question is,
is there a faster way of doing that rather then doing it indiviaully. example
colunm A ----> colunm A
326 *326*
12315 *12315*
312 *312*
21 *21*
12

 

[Guest]

In column B ="*"&a1&"*" and copy down.

copy paste special values in from column B to column B

Delete column A

 

[Guest]

You could use a custom number format like this

\*#\*

this way your cells will have the stars but their value will still be numbers.