View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Tyro[_2_] Tyro[_2_] is offline
external usenet poster
 
Posts: 1,091
Default Automatic Negative Column

What does "format" mean? Show positives as negatives and negatives as
positives without actually changing the cell values? If so, use custom
formatting.

Tyro

"Mrs. Rathbone" <Mrs. wrote in message
...
Is there a way to "format" a cell so if i enter a positive value, it
converts
to a negative amount? No formulas pleez as I cannot insert a column (it's
a
financial thing).