View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
bsobaid bsobaid is offline
external usenet poster
 
Posts: 2
Default setting numberformat for -ve numbers

Hi,

I want to set the numberformat property such that if the value in cell in
whole sheet is a -ve number then it should be displayed in red color with
brackets around it.
What should I set the numberformat property to ??
Is there a list of values available that numberformat can be set to ?

Thanks,