How can I setup a custom excel cell format to display jscript fie.

M

mrmodine

"I am trying to format an excel cell to display the following information but
it keeps erroring out:

+"DATA"

I need it to appear exactly as above except DATA will be various other types
of information but I need the +" to display.

I'm sure it can be done but I'm not getting anywhere trying it.

Please help.
 
F

Frank Stone

hi,
try this:

=("+" & Data) or =("+" & A1)
where A1 is the cell address.

hope it helps
regards
Frank
 
Top