Apologies if a thread already exists on this (Haven't found it 
)
I use Excel 2010. I encounter this problem on only 1 of my files:
Every time I open it, the number formatting is changed from numbers into date
. I always have to change back to numbers.
It is a large file with lots of data organized in database from which I get Pivot Tables in different tabs. I get the data monthly from a site and receive them in CSV. I usually copy / paste as value (no formatting) and work from there. When done, I save (.xlsx). When I open again, still formatted in dates. Not sure what to do here.
Thx in advance for helping...
)I use Excel 2010. I encounter this problem on only 1 of my files:
Every time I open it, the number formatting is changed from numbers into date
. I always have to change back to numbers. It is a large file with lots of data organized in database from which I get Pivot Tables in different tabs. I get the data monthly from a site and receive them in CSV. I usually copy / paste as value (no formatting) and work from there. When done, I save (.xlsx). When I open again, still formatted in dates. Not sure what to do here.
Thx in advance for helping...
