putting symbols front and

[Jammal]

in column a i have 300+ numbers and i want to put a * sign in on both side of
numbers in order to look it up. my question is that is there a fast way of
putting that (*)symbol in rather then doing in indiviually and same for
taking it out?
i.E
A
*159*
*123*
Faster way of putting star?

[davesexcel]

if you goto format cells
number
custom
and then in the custom box type "*"#####"*"
this should work for you

[CLR]

Formatting the * in place will only make it LOOK like they are
there..........if you really want them there,
In a helper column put this formula and copy down.........then do Copy >
PasteSpecial > Values on the column to eliminate the formulas and delete the
original column if desired............

="*"&A1&"*"

Vaya con Dios,
Chuck, CABGx3


"Jammal" <Jammal@discussions.microsoft.com> wrote in message
news:3A6EEBE7-337B-4052-85BD-032E2CD334FA@microsoft.com...
> in column a i have 300+ numbers and i want to put a * sign in on both side
of
> numbers in order to look it up. my question is that is there a fast way of
> putting that (*)symbol in rather then doing in indiviually and same for
> taking it out?
> i.E
> A
> *159*
> *123*
> Faster way of putting star?
>