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

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

copy paste special values in from column B to column B

Delete column A

"Jammal" wrote:

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

You could use a custom number format like this

\*#\*

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

"Jammal" wrote:

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