Thread: Adding negative currency automatically
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Carim Carim is offline
external usenet poster
  
Posts: 510
Default Adding negative currency automatically
Hi Clive,

Use Format Cell Number Custom
and enter your customised format, e.g. -$#,##0.00


HTH
Cheers
Carim

Reply With QuoteReply With Quote