Add asterisk to excel cell

How do you add an asterisk to the begining of a excel cell? or replace
the zeros with a asterisk? For example, data come in the cell as 01222
but I want it like this:*12222


Thanks,

Jim


--
jblack35

if 01222 in A1
B1> ="*"&value(A1)
but * is an operator, so expect to have unexpected trouble with this
down the road.

On Mon, 7 Mar 2005 21:17:58 +0000, jblack35
<jblack35.1ljm5o@news.officefrustration.com> wrote:

>
>How do you add an asterisk to the begining of a excel cell? or replace
>the zeros with a asterisk? For example, data come in the cell as 01222
>but I want it like this:*12222
>
>
>Thanks,
>
>Jim