Why won't Excel recognise any entry in a cell that contains a ~. For example I have lists of job numbers such as FI9CMR~002 or RE1RE~~004.
The ~ is essential to us in order to pad out the number to 10 characters. This data is exported into excel from another database.
Advice or guidance appreciated.