 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / New Users / November 2007Insert 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..  SignatureMugge The dane SignatureMugge 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. [quoted text clipped - 3 lines] > I have tried 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. [quoted text clipped - 3 lines] > I have tryed userdefined formatting but without any luck... > Thank you in advance.. >Hello, this may be kiddstuff to yuo but a huge problem to me and I'm sure >I need to insert the * character ex. [quoted text clipped - 3 lines] >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 Thank you Ron. It was great. Have a nice day. SignatureMugge 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. [quoted text clipped - 3 lines] > I have tryed userdefined formatting but without any luck... > Thank you in advance.. >Thank you Ron. It was great. Have a nice day. Glad our solutions worked for you! --ron |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.