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

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

Insert a special character in 1st and last position into a cell
 

Try this custom format:
\*#\*

Does that help?
--------------------------

Regards,

Ron (XL2003, Win XP)
Microsoft MVP (Excel)

"Mugge" wrote in message ...
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

Insert a special character in 1st and last position into a cell
 

On Wed, 24 Oct 2007 05:12:02 -0700, Mugge
wrote:

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..

If you just want to change the display, then

Format/Cells/Number/Custom type: \*#\*


--ron

Insert a special character in 1st and last position into a cell
 

Thank you Ron. It was great. Have a nice day.
--
Mugge
The dane


"Mugge" skrev:

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

Insert a special character in 1st and last position into a cell
 

On Tue, 6 Nov 2007 04:32:01 -0800, Mugge
wrote:

Thank you Ron. It was great. Have a nice day.

Glad our solutions worked for you!
--ron