Cannot change number of decimal places
I have attempted to assign 4 decimal places to all values in a large table of values. Using the usual method of highlighting the whole array of cells and using FORMAT-CELLS-NUMBER-decimal places 4 does changes most of the values to 4 decimal places but a few columns show 0, 1, 2, 3 or other number of decimals. Using the Increase or Decrease Decimal button on the Home ribbon does nothing, although the increase/decrease decimal buttons work fine on the columns of numbers successfully set to 4 decimal places. Yet another glitch in this worst-ever version of Excel.
cannot get cell to stop entering decimal. It has been changed in Format to 0 and now comes back like its rounding
I think this comes from a larger problem, where databas numbers appear on the screen, but as "general". I find they are useless. every column needs to be formatted. If text, "Text to columns" clicking "Text" on the last popup. If they need to be numbers, you can just use the "Text to columns" and immediately hit "Finish". Once you have done this, they respond to the decimal command, although only the currency command if you open it and select the currency you want.