Add asterisk to excel cell

J

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
 
B

Bob Tarburton

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