I'm working with a sheet of contact details and very, very annoyingly, the column of phone numbers has some values messed up.

My numbers are generally 01XXXXXX , or 08XXXXXXX , or if 353XXXXXXXXX

Excel converts the 01XXXXX numbers to 1XXXXXX and the 353XXXXXXXXXX numbers it displays in some scientific notation.

I've tried changing the format of the column to both text (hoping that it would restore my leading zeros and special (mobile phone - Ireland), but that doesn't help.

In one of the cells where a number has been converted to scientific notation, the number is shown as 3.53XXXE+XX, but if I select the cell, the correct number is shown in the bar at the top of the sheet (dunno what it's called).

Some other threads here mentioned changing the fixed decimal, but that doesn't seem to have helped me.

What else can I try, please?