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

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

Guest

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..
 
Try this custom format:
\*#\*

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

Regards,

Ron (XL2003, Win XP)
Microsoft MVP (Excel)
 
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..
Click to expand...

If you just want to change the display, then

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


--ron
 
Back
Top