Change Default Number Format

I wish to change the default number format, ideally automatically, so that when I open a new worksheet, it already has the new number format e.g.: #,##0;[Red](#,##0)
I suspect that I could have a macro written to do this and then run that macro on start up (both things that are beyond my current skill set), but I was wondering if there was an easier way to do this. e.g.: in 'Options' somewhere. All suggestions welcomed.

Welcome to the forum Noel,

I prefer to set Excel to have the option of negatives (red and in brackets) available to me.

To do this, go to the START menu for windows. Clock on Control Panel.
Under Clock, Language, and Region, select Change date, time or number format which is under Region and Language.
Click the Additional Settings button on the Formats tab
On BOTH NUMBERS AND CURRENCY tabs, change the Negative Numbers option to (1.1)

Now when you go into Excel to change the format of a cell, under the Numbers option, you will see the (1234.10) option.

I hope this helps, please let me know!

Regards,

David


- Please click on the *Add Reputation button at the bottom of helpful responses.

Please mark your thread as SOLVED:
- Click Thread Tools above your first post, select "Mark your thread as Solved".

Hi Guys, great responses, thanks for the support.
David Coop - did what you suggested and change regional settings but it still meant that I had to select the bracketed option once I entered Excel, so it only half solved the problem,
Humdingaling - This worked perfectly and has solved the problem, and opened up other opportunities to fine tune the default workbook, font size & Type etc. I am running Office16 so finding the XLSTART folder was a bit different but I got there in the end. C:/Users/myname/AppData/Roaming/Microsoft/Excel/XLSTART - Important: the file has to be saved as "Book.xlsx" not Book.xltx as I first thought.
Mr Shorty - Thanks for the suggestion and I imagine that it would work too, but Humdingaling's suggestion has solved my problem.

Thanks again guys - you've been a great help and now I don't have to manually change every single spreadsheet that I create. Big time saver.

Now you've got me nervous
- Interestingly when I went to save the Book.xlsx file into the XLSTART folder, the folder was showing as empty. I had "Show hidden files" turned on, and when I did the save I was not prompted by a check to see if I wanted to overwrite an existing file. So I assumed that the folder was in fact empty. Nevertheless, when I open Excel now, the default workbook has the 'red bracketed negatives' which was what I was after.
Not sure how to get back to the default workbook - other than (a) deleting the file I created, or (b) changing the created back to the factory default.
For now, maybe I will leave things as they are - it works the way I want it to and as the saying goes "It aint broken...."

Thanks Great advice - Shall do.