Right-click Format Cells Custom Type
Does that do it for ya?

Ryan--

--
RyGuy


"Jamal" wrote:

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.