Forum Discussion
Issue with automatic custom number formatting in Excel
Hello Excel Community, I'm encountering an unusual behavior in Excel where it seems to automatically apply a custom number format under certain conditions, without my input. Specifically, when I ...
If you stay on such cell and Ctrl+1 which format do you see? And is it the same in exactly new workbook?
- Hi Sergei,
It has this format [t].mm.ss - https://app.screencast.com/7ETMpcbFbWCdZ
And yes every new workbook I open and I don't know why or how i ended up there.Perhaps you have custom template Where are my custom templates? - Microsoft Support which applies elapsed time format to all cells. **bleep** immediate workaround you may select entire sheet->Ctrl+1->apply General format
- @Sergei
Doesn't look like i have any custom templates.
I have tried to make a video where i post different numbers, see here: https://app.screencast.com/o88L2MUo034gM
I have also tried to do Ctrl+1 for the whole sheet, doesn't help.
