One way:

=TEXT(B3,"\*mm/dd/yyyy\*")

In article ,
"no_junk_mail" wrote:

I'm trying to use a function to take the value of cell (B3 contains
"08/31/2005", for example) and copy it to another cell (G3, for example),
and add a preceeding and trailing asterisk = I tried typing the following
=("*"(B3)"*") into the formula bar while the cursor was in cell G3 - but all
I ended up with in G3 was - "*"(B3)"*" - I'm sure that this is an easy one
for someone - I'd appreciate any suggestions - THANKS!