Excel 2016 spontaneous cell format change? | General Excel Questions & Answers

Excel 2016 spontaneous cell format change?

Anne Walsh

Member

Members

Excel Analysis Toolpak

Power Query

Forum Posts: 36

Member Since:
May 2, 2014

Offline

July 21, 2016 - 2:06 am

My problem is once I have completed an excel file, closed and return to same it has spontaneously formatted certain cells in the work book into date format – to solve this problem I have to highlight column, go to custom format & delete the weird date formats that have appeared at end of list. Sometimes it might not be a date format problem but an accounting format problem.

Any suggestions? Thanks

Mynda Treacy

Admin

Forum Posts: 731

Member Since:
July 16, 2010

Offline

July 21, 2016 - 1:29 pm

Hi Anne,

I've never heard of that before. Are these cells in an Excel Table or just regular cells? Do other people have access to this workbook? Does it happen with other workbooks?

Mynda

Anne Walsh

Member

Members

Excel Analysis Toolpak

Power Query

Forum Posts: 36

Member Since:
May 2, 2014

Offline

July 21, 2016 - 7:59 pm

As far as I know they are regular cells. The user is a pretty experienced user and she is feeling frustrated by that. Let me check with her if it's one workbook or more..thanks. 🙂

Mynda Treacy

Admin

Forum Posts: 731

Member Since:
July 16, 2010

Offline

July 21, 2016 - 9:22 pm

Also see if you can replicate it on your PC or another PC. If you can't then it's something specific to her PC.

Catalin Bombea

Iasi, Romania

Admin

Forum Posts: 403

Member Since:
November 8, 2013

Offline

July 21, 2016 - 11:58 pm

You can also try this:

Create a new excel workbook. When you open it for the first time, which is the default cell format displayed in Home tab, Numbers section? It should be General. If the default format is not General, then your default excel template was modified, you have to open that book.xlt file to customize excel defaults.

Here is a link where you can learn more: Customize-how-Excel-starts