Thread: putting symbols
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Sloth Sloth is offline
external usenet poster
 
Posts: 252
Default putting symbols

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