putting symbols

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
In column B ="*"&a1&"*" and copy down.

copy paste special values in from column B to column B

Delete column A
 
You could use a custom number format like this

\*#\*

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