Phone numbers displaying as scientific notation no matter what format selected

its got to be text, format cells before you put data in
or select column with numbers
data /text to columns
click next
click next again
in the column data format click the text button
click finish
when thats done come back and we'll sort the missing 0
probably =IF(LEFT(A1,1)="1","0"&A1,A1)

That worked a treat, thanks so much.

So now, I have all the numbers displayed as they were put in, except some of them don't have leading zeros.

Instead of replacing the leading zeros, I could just put a +353 in front of all the numbers that don't have one already.

Appreciate it if you could point me toward instructions on that!

Sorry it to so long for me to reply, I didn't know anyone had answered. (must check my notification settings)