Changind Default Number Format

A

Amr Tabbarah

The Default/Standard Number Format is Decimal Places (2) and no 100
separator selected.

How can these be changed so that the default becomes Decimal Places (0
and 1000 separator selected for all future Excel sessions?

Thanks
 
A

Amr Tabbarah

Thank you BrianB.

I tried it and it worked.However, it seems that the Format/Style/Norma
is restricted to the specific workbook when it is modified.

Is it possible to have similar format for all workbooks or is this i
restriction we have to live with?

Thanks,



Am
 
B

BrianB

Didn't know that. You can make up your own default workbook and save i
as book.xlt in your XLSTART folder. Excel will use this whenever yo
want a new workbook
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Decimal Place goes crazy when using the "&" Sign. 4
Excel 2002 : How to set thousand separator at tool bar ? 2
Importing txt-file with "." (= dot) as decimal separator doesn't w 2
Cannot enter numbers in Excel 2003 1
Formatting Question 4
General Format altered/corrupted? 1
Automatic rounding and placement of decimals. 1
Access stripping decimal places in query 1

Top