Change default cell format for new tab

piyush.636

New member
Joined
Dec 5, 2018
Messages
2
Reaction score
0
Points
0
Excel Version(s)
16
Hi All,

for one of my excel files, every new tab opens with default cell format as "Date". This is the problem with only one excel file, for other files the new tabs open with "General" format for cells. Not sure what has gone wrong with this particular file.

Any suggestions on how to fix this and reset the cell format to "General" for this file too.

Thanks in advance for help.
 
Thanks for the response @Pecoflyer. I read the thread , but it states the obvious as to how to change the format once the new sheet is created. I would be interested to know how can I avoid that and make sure that every new sheet opens with "General" cell formatting by default. Any new pointers on this?
 
I can only do that much, that is, searching the Net.
Perhaps some other member can answer
 
Any suggestions on how to fix this and reset the cell format to "General" for this file too.
Can you attach the relevant Workbook here to download (previously deleted data)
 
Back
Top