Blog


How to reset the default cell formatting in an Excel spreadsheet

One of the more irritating things you can come across in someones elses spreadsheet (on the basis that I've never managed to reproduce it myself) is when somehow the default style has been changed to spit out a daft format of 00:00:00 for seemingly any number.

This is especially apparant of you are a regular user of the clear formats function. It is a staple of mine in a few different circumstances, notably in clearing other peoples gash formatting & when you want to quickly see more significant figures regarless of the current formatting you have.

There are two ways to do this, you can put it in a macro or manually

Sub ResetNormalStyle()
    ActiveWorkbook.Styles("Normal").NumberFormat = "General"
End Sub

or my favorite personal style

Sub ResetNormalStyleMC()
    ActiveWorkbook.Styles("Normal").NumberFormat = "#,##0,_);(#,##0,);-_)"
End Sub

 


Share page

Subscribe to newsletter

Search Posts

Back to top