CODEWITHSUNDEEP
excel
user3210171
user3210171

Reputation: 13

Excel 2013 default format is Date when adding a new sheet - how to change to General?

I have a complicated Excel workbook and for some reason, when I add a new sheet, the default format for the cells is Date and not General as is the case in my other Excel files. How do I fix it so if I add a new sheet, the default format is General? It's only this workbook. If I open a new excel file or even add sheets to other excel files, the default format is General.

Upvotes: 0

Views: 3203

Answers (1)

Ron Rosenfeld
Ron Rosenfeld

Reputation: 60464

This has been reported off and on for many years. For reasons unclear, the Normal cell style gets modified to date. So go to the Home Ribbon and, on the Styles tab, right-click on Normal and select Modify. Change it back to General

Upvotes: 3

Related Questions