I received an Excel file (.xlsx) that has a column like this:
1.6000 1.6050 1.7000 5.0
And so on. The column appears to be a number type. I need to convert this column to text. When I try to Format Cell and change to Text, it changes the data like so:
1.6 1.605 1.7 5
This is incorrect and does not match the actual data. How can I change this column to text without losing data?