I'd use two cells--one for the input and one for the value that I wanted to use:

Say A1 for the user input, then put this in B1:

=-abs(a1)

You could even hide that column B if you wanted to make it prettier.

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

--

Dave Peterson