Forum Discussion
JBravo1217
Sep 17, 2023Copper Contributor
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...
HansVogelaar
Sep 17, 2023MVP
Make sure that the cells are formatted as General or as Number.
Select an empty cell and copy it.
Select the range with left-aligned numbers (it's OK if there are already right-aligned numbers among them).
Right-click in the selection and select Paste Special... from the context menu, or click the lower half of the Paste button on the Home tab of the ribbon and select Paste Special... from the drop down menu.
Select Add, then click OK.
JBravo1217
Sep 18, 2023Copper Contributor
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?
- HansVogelaarSep 18, 2023MVP
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...