CODEWITHSUNDEEP
excel
Texas
Texas

Reputation: 453

Save number format by default in Excel

I would like to save number format with comma delimiter as default in Excel. So number 123456.78 will always look like 123,456.78

How can I do this ?

Upvotes: 0

Views: 663

Answers (2)

Ron Rosenfeld
Ron Rosenfeld

Reputation: 60174

Home/Styles: Right click on Normal and select Modify

Change the Number style

  • from General either to Number + use thousands separator
  • or, if you want to use Scientific notation when over a certain amount, perhaps

[<100000000]#,##0.00;General

  • or whatever you want.

Upvotes: 1

Dominique
Dominique

Reputation: 17493

Excel general number formatting is based on your locale. This contains a "Digit grouping symbol", filling this is will change your format accordingly.

Be aware this is not only done for Excel, but for every application on your computer, based on this format.

Upvotes: 1

Related Questions