Add asterisk to excel cell

[jblack35]

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

 

[Bob Tarburton]

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