Apply Number Format to all New & existing spreadsheets
Asked Mar 18, 2009, 06:15 PM
I've been trying to change the negative number formats or generally apply a similar format to all existing & New spreadsheets inregards to numbers. Tried changing the Regional settings but still no result. Any help on how to apply the format to all the cells/spreadsheet at once would be greatly appreciated.
When you open an Excel workbook, it reads the default formats and styles from a template file. That's why I needed to know what spreadsheet you were using. You need to save your formatting in that file which is book.xlt as the article JB linked to points out.