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.
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.Strange. In E14 in formula bar you have the same number as in the cell
in G14 you have elapsed time format
If that's new file it shall be the template which predefines formats.
Do you have something related to Excel in %appdata%\Microsoft\Templates\ ?