How to get rid of date format

[bobby_smith]

Hi Guys,

I have a workbook where it seems the date format is default in each cell. If I click in any empty cell, instead of format being the default "General" its date.
If I insert a new sheet, the entire new sheet is formatted as date in the empty cells.

I would like to know if there is a way to fix this or whether I need to rebuild the workbook from scratch.

Thanks in advance.

 

[shg]

Check the number format for style Normal.

 

[bobby_smith]

Would you mind expanding on this please as I do not understand the solution presented.

Where do I navigate to check/change "Check the number format for style Normal"

Thanks

 

[bobby_smith]

I was able to find the solution on this thread: https://www.mrexcel.com/forum/excel...ed-has-date-format-default-all-its-cells.html
Its the #8 post/response.

It took me a while to understand the instructions so I'm sharing my understanding of the instructions. My instructions is based on Excel 2016, but I think it should be the same for others

Go to the Home tab -> navigate to the styles group ( this is between the Number and the Cells group). The style group contains the Conditional Formatting, Format as Table, and Cell Styles. Depending on the width of your monitor you you will see "Cell Styles" or you will see the colored working such as "Normal in White, Bad in Pink, Good in green". See screenshot here:

On the cell styles, select "Normal" ( this was under the "Good, Bad, Neutral")

Right click on Normal -> select modify -> format -> this will then take you to the format cells window. Select "General" -> OK -> OK.

Problem solved.

 

[bobby_smith]

Here is an image of the "Cell Styles" . It took me a while to figure out what it was. https://ibb.co/juNhuJ