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

M

Mugge

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

Ron Coderre

Try this custom format:
\*#\*

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

Regards,

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

Ron Rosenfeld

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How do I install Microsoft Equation 3.0 back to Office 365? 0
Excel does not accept text format! 0
Place picture in Excel cell 0
WORD VBA Search and switch to advanced ... 1
Pasting a cell into bookmarked table from excel vba 1
Special Character at End of Each Table Cell 2
Table Preferred width is changed when pasting 1
Cell format crosstalk 0

Top