To clean up the messy data, it needs to be loaded into the Power Query Editor.
Click "Format" next to the Replace With field, and select the correct number format in the Number tab (in this case, ...