Wow. this is a doozy: Any number I enter is automatically converted to a decimal percentage. For example:
If I enter '3', the number is converted to '.03' in the cell and in the formula bar. If I enter '502', it's converted to '5.02'. Nothing I do changes how numbers are converted like this. If I create a new document, it converts numbers like this. If I open an old file that has data in it, selecting a cell and pressing return changes the number like this.
I can format the cells as TEXT, but we need these numbers for formulas and totals, and TEXT-formatted cells aren't counted as numbers.
For our workaround right now, every field we create with numbers has a field next to it that multiplies our entry by 100 and we get the actual number we want, but it makes it impossible to send our sheets to suppliers or remote offices.
Please help, as our Excel has been rendered almost useless and unbelievable frustrating. By the way, this started a few weeks ago and nothing noteworthy happened to start it.