Weird Excel double-decimal places
Hello Everyone!
In all my years working with Excel I have never seen it create a chart label that looks like this: 37.5.0. What the heck is with the double set of decimals?
Everything looks normal in the chart settings; we have been through it many times. When we change one, then more weirdness pops up elsewhere.
We are using Word to create a final report and using Excel on the back end to edit chart data.
Here is an example. We tried changing the settings for the 37.5.0 and then the "neither agree nor disagree" changed to 25 from the original 25.0! The 37.5 is the correct way we want them all to be. The settings for the other two data labels don't appear to be any different from the one for the 37.5. Any ideas about what might be going on?
In addition to trying all the settings for data labels, we've tried rebooting the software, and then also rebooting the whole system. That doesn't do any good either.
Completely stumped with this one.
[link] [comments]
Want to read more?
Check out the full article on the original site