| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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 |
|
#6
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Return True if cell contains special character | Excel Discussion (Misc queries) | |||
| how to insert a special character (arrow) in IF statement | Excel Worksheet Functions | |||
| Can I create a special character for the Character Map? | Excel Discussion (Misc queries) | |||
| inserting special character in a cell as a macro | New Users to Excel | |||
| Insert a special character before and after a word | Excel Discussion (Misc queries) | |||
Hybrid Mode
