Forum Discussion
Cell Style Formatting Problem
I had built an expense report with Excel 2010 which has a mix of formats that consist of General, Currency and Custom. Now that I am using Excel 2016 for this expense report, there is a formatting a...
Hi Sergei,
I had this problem in version 2010 in a lesser frequency than version 2016. I checked that forum link you gave me for Excel 2007 and saw the supposed fix offered by a couple of MS people. The fact is, both responses said to fix the Cell Style. I had always fixed the Cell Style a number of times where I would modify the Normal back to General. Unfortunately, this problem of the General cell format being changed to the Date format would occur every time I sent this Excel file to someone else. I would then look at the Cell Style where it had changed again. As I said, this was my Expense Report, which is why I had to share that in my company.
I get the same thing. It doesn't seem to effect all cells with a vlookup formula but it does change some. Locking cells or protecting sheets or workbooks doesn't seem to help but it looks as if hidden sheets aren't changed