View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
CLR
 
Posts: n/a
Default Make cells negetive amount

If you only want the display to APPEAR to be negative, then you can just do a
custom format of -#### on the cell. The actual number tho, if used in
other formulas will be positive.

Vaya con Dios,
Chuck, CABGx3



"ggant" wrote:

I want to make any value that is put into a cell to be a negitive value. So
if 5.00 is put in it's value shows as negetive value. It this possible?