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

[Guest]

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

 

[Frank Kabel]

Hi
try
'+Data

 

[Frank Stone]

hi,
try this:

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

hope it helps
regards
Frank