custom number format

siliconguy

New Member
Joined
Sep 22, 2002
Messages
1
I use a custom number format to drop an "M" at the end of a number but I can't figure out how to add it to some default list so that it's in /format/cells/number/custom when I open a new workbook. So far I have to re-enter the format each time I open a new workbook.

Thanks.
 

Excel Facts

How to fill five years of quarters?
Type 1Q-2023 in a cell. Grab the fill handle and drag down or right. After 4Q-2023, Excel will jump to 1Q-2024. Dash can be any character.

kskinne

Well-known Member
Joined
Feb 17, 2002
Messages
1,267
Office Version
  1. 365
Platform
  1. Windows
apply this formatting to a cell or cells in your personal.xls file located in your XLSTART folder (path is: program filesmicrosoft officeofficexlstart)
if you don't have a personal.xls file, open a blank workbook, add this formatting to it, then save it to the above-mentioned path with the name 'personal.xls'.

by doing this, you will notice that your custom formatting appears in the custom format list when you open a new workbook

HTH
kevin
 

whitemc

New Member
Joined
Sep 23, 2002
Messages
15
Will this work for pivot table formats also? I use pivot tables a lot, and I haven't found a way to change the default format. Number fields are always general. I need to always see these in comma number style/format. Is there a way to change the startup default format for pivot table number fields?
 

Forum statistics

Threads
1,144,444
Messages
5,724,391
Members
422,548
Latest member
Cuprian

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top