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

Format cells as time
Select range and press Ctrl+Shift+2 to format cells as time. (Shift 2 is the @ sign).
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
 
Upvote 0
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?
 
Upvote 0

Forum statistics

Threads
1,218,845
Messages
6,144,801
Members
450,567
Latest member
Mplz

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
Back
Top