I want the default cell format to be the general category so that cells automatically recognise dates etc but I want the default number format within the general category to be #,##0;(#,##0);-. Does anyone know how to change this?
Thanks
I want the default cell format to be the general category so that cells automatically recognise dates etc but I want the default number format within the general category to be #,##0;(#,##0);-. Does anyone know how to change this?
Thanks
As far as I know, what you want is "hard coded" into Excel. You can however create a template with the formatting that you want.
Thiis link has directions:
http://www.softwarepro.com/articles/...t_workbook.htm
Last edited by newdoverman; 12-05-2013 at 07:54 PM.
<---------If you like someone's answer, click the star to the left of one of their posts to give them a reputation point for that answer.Ron W
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks