View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.setup
Amy
 
Posts: n/a
Default Can you set to default the # of decimal places in Format Cells?

I keep having to change the Decimal places from 2 to 0, check the "Use 1000
Separator" and select for "Negative numbers" the red with parenthesis
formatting. Is there a way to set these to a default so I don't have to keep
doing it?

There is an option to fix the number of places in Options, but it doesn't
work in this case.

Thank you!
Amy