Thread: Negative Values
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Zygy
 
Posts: n/a
Default Negative Values

Is there a way of ALWAYS getting the figures of a negative value of currency
shown in read on a worksheet? If there is how do I arrange it?
I tried FormatCellsNumber and Currency, where I highlighted the red -£
figures, but I still get the negative Currency numbers in black. My OS is
Win.XPPro.