Hi,

You need to adjust the format of the cell - this one for instance: -*
#,##0_-;-* #,##0_-;_-* "-"_-;_-@_-

Notice that the format starts with "-".

Go to Format-Cells-Number and paste this format in the custom part.

Cheers,
Jon

"es" wrote:

Hi
I want the value that i type into a cell always to be
negative

thanks