So working with custom formats for cells (under Right Click Cell > Format Cells...> Number Tab > Custom), Excel will list a few default custom formats like this (I'm talking about the right side that starts with General, 0, 0.00, etc.). When I enter my own custom formats they will appear at the bottom of the list. I'm noticing Excel adding random formats to this list, about several minutes or more after I start a workbook. If I close Excel and re-open it the random formats are gone, but they sometimes return after working on the workbook for some time. Right now these are the five formats that are consistently appearing without me entering them:
- [$€-x-euro2] #,##0.00_);[Red]([$€-x-euro2] #,##0.00)
They don't show up in this list when I start Excel, so I know they aren't default custom formats and I'm not adding them in myself. I wasn't even using formulae in one of my workbooks and they appeared, so even if a formula caused Excel to automatically generate a custom format, I'm still experiencing the problem even when I haven't used a single formula on a workbook.
What is going on with this?
Edited by Lxno78, 05 August 2016 - 10:05 AM.