You would do that by formatting the cell.

Anticipating your next question, if you want to use green if the price is up,
and red if the price is down, use Conditional formatting.

Post back if you want help with either of these. A specific example would be
useful so we can help you get exactly what you want.

--
Regards,
Fred


"Templeton" wrote in message
...
Thankyou, but is it possible to colour code them as well??

"Fred Smith" wrote:

Use the InsertSymbol... command. It will tell you the character number of
the
symbol you want to use. Then put that in an If statement, as in:

=if(a1<b1,char(223),char (221))

Does this help?

--
Regards,
Fred


"Templeton" wrote in message
...
I want to be able to display up and down arrows pertaining to price
movements
in a spreadsheet?