View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.newusers
Mugge Mugge is offline
external usenet poster
 
Posts: 3
Default Insert a special character in 1st and last position into a cell

Hello, this may be kiddstuff to yuo but a huge problem to me and I'm sure
I need to insert the * character ex.
the value in cell A1 is 1
I want to change it to *1*
I want to change the hole column to the *#* format.
I have tryed userdefined formatting but without any luck...
Thank you in advance..
--
Mugge
The dane