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 ...
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.
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\ ?
- Agreed, it is very strange!
My templates looks like this: https://app.screencast.com/UTW9WNcY0SqCa- I finally found the issue and it wasn't even in Excel...
My windows settings was wrong as my region format was wrong. https://app.screencast.com/l8fmLUM60z9oH
Thanks anyway for trying to help me Sergei 🙂