Inserting Symbols

M

msb

i am currently working on a report that displays variances for 2004 an
2005. What I am trying to do is build an If statement or a Macro whic
will allow me to represent the variance in symbolic form.

For example:
if the difference for a certain field is -10, i would like to represen
that by 10*(arrow pointing down)..so that graphically the user can se
that the difference of last year and this year is down by 10percent...

i hope i am making myself clear, but the problem is that there is n
'insert symbol' in excel! i am working with excel 2000.

thanks! ur help is highly apprecited
 
D

Dave Peterson

You could open CharMap
(Windows start button|run|Charmap)
and copy|paste (and format the cell or character with that font).

or...

Chip Pearson has an addin that may help (if you're using xl2k or lower).
http://www.cpearson.com/excel/download.htm
(look for Symbolizer and make sure you get the correct version)
 
Top