I have an Excel spreadsheet that has been created from multiple .CSV files. In some cells there will be a number 605100011781 and in others 0605100011781 (Preceding 0 placed in bold to highlight the difference). They are or should be exactly the same, but Excel sees one as a number and the other as general/text. Normally if you place a preceding O in front you would hit ' in Excel and when you look at the cell, this would be shown '0605100011781 Here it isn't, so there is some other hidden character keeping the format different from what I want. If on the formula line I place my cursor in front of the 0 and just backspace, then Excel will treat it as a number again and show it as 605100011781 I need to see what that special character is so I can replace is as there are thousands of lines and thousands of different numbers all with the same issue. Is there a way to show what that hidden character is in front of the number?
Many thanks
Many thanks