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?