Thread: Number format
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Jamal Jamal is offline
external usenet poster
 
Posts: 26
Default Number format

How do I set the default number format to be #,##0;[Red](#,##0), which will
avoid the dash sign for nrgative numbers and add a thousand seperator. I am
still using Excel 2000. Thanks for your help.