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
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