Forum Discussion
Excel Won't Recognize Copied Cell Data Unless I Hit Enter On Each Cell
I am relatively new to Excel and I am trying to make line charts for each of these copied datasets. The issue I am having is that I have to individually press enter on each cell for the number to sho...
The cells are already formatted as Number. I'm sorry I don't understand your instructions. Why should I select an empty cell and copy it?
When we use an empty cell to add its value to the cells with the left-aligned values, Excel treats it as if it contains 0. By adding 0 to a text value that looks like a number, we force Excel to convert that text value to a number.
Why don't you try it? It won't take much time...