View Single Post
  #2   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


--
Mugge
The dane


"Mugge" skrev:

Hello, this may be kiddstuff to yuo but a huge problem to me and I'm sure You easily can solve my problem.
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 whole column to the *#* format.
I have tried userdefined formatting but without any luck...
Thank you in advance..
--
Mugge
The dane