Prasad,

If you don't need to use the numbers in any calculations later, you could
just fudge it by using a custom format to put a negative in front of the
numbers even if they're positive.

"-0;-0" would do it.

Eric


"Prasad" wrote:

How do I set the value in my work sheet cells so that data eneterd in the
cell autumaticlly converts to negative.

EG. if I typed in 25, I would liek the cell to show the value as - 25.

Prasad Gopinath