How to remove the trailing space from cells in Excel that prevents formatting spreadsheet
...
Click into the first cell. Notice there is a space after the data.
Highlight the trailing space in the toolbar. This space represents a non-printable ASCII char 160 that needs removed to be able to format the cells as a number.
...
Highlight the trailing space and copy it (use CTRL + C). This will copy the non-printable ACII ASCII char 160 that cannot be seen.
...