Sometimes Excel cells show a partial or masked value instead of the desired value.
Double clicking the cell usually fixes the issue for the cell and the info is presented correctly.
How can we avoid manually clicking each cell and batch convert them all?
Select cells in the column you wish to fix -> Click the “Data” tab/ribbon title -> Click “Text to Columns”.
You will be presented with a wizard and many options. In most cases, clicking on “Finish” will simply work.