Excel 2010 Changing default Blank Page Settings

**Chris Hankey** · 04-23-2012, 08:43 PM

Good Afternoon

My office recently upgraded to Office 2010 and we would like (in the accounting department that I work in) to change the default number formating in a blank sheet to Number, 0 Decimals, using seperators, from the current default of general format number.

I have looked for the Book.xltx file to replace but can't see it any where.

Please help, can this be done?

Chris
Auckland
New Zealand

**davesexcel** · 04-23-2012, 09:03 PM

Maybe checkout
File=>options=>Advanced

**Chris Hankey** · 04-23-2012, 09:05 PM

Thanks, had looked there, nothing that will edit the default setting.

**davesexcel** · 04-23-2012, 09:17 PM

In the same advance window there is a line
At startup,open all files in:
You can enter the file address there.

I also found this bit of code

  If MsgBox(Application.StartupPath, vbOKCancel) = vbOK Then
    Shell "Explorer " & Application.StartupPath
  End If

It shows where your startup file is located.

**Chris Hankey** · 04-23-2012, 10:01 PM

Found it.

You can save a user formated defined template book to:

C:\Users\<username>\AppData\Roaming\Microsoft\Excel\XLSTART

Beware that in overwriting the general format for the cells, it will not register dates etc, you will need to manually change this going forward. Note that there is no pre-existing template in that location.

Thanks everyone