Forum Discussion
Cell Formatting Decimal Cutoff
Hello all, I've been absolutely stumped on this issue. As you can see, this cell has .006 but Excel always rounds it to .01. I've set the default decimal places to 3 in Windows per a separate sugge...
You can set the number format to Number with 3 decimal places.
The number format does not matter for XLOOKUP.
- Thanks Hans, technically it's not a number so I don't want it to set to number.
In that case, you'll have to either format the cells as Text before entering the data, or prefix the values with an apostrophe.
I've been doing some experimenting on my personal Excel (vs. work) and I happened upon perhaps some explanation. I accidentally missed a digit when I typed it, and as general, it displayed the full .006. It must be that Excel has a hard limit on the # of characters for general before it starts to "round up" on its own.
