Help with leading zeros disappearing!

[sterjohn]

Hi, I am hoping someone can help me here?
I am trying to add text to the end of a list of mobile phone numbers in a column, (eg: 04555555555@xxxxxxxxxxx.com.au)
I have the mobile numbers in one column and @xxxxxxxxxxxx.com.au in another column.
When I try to combine the numbers and letters in a cell, the leading zero on the phone number disappears no matter what I try.
Any advice would be very much appreciated before I go bald from pulling my hair out..
Kind regards,
JS

 

[sterjohn]

You're welcome John. I'm glad to have been able to help and thanks for the feed back.

Cheerio,
vcoolio.

Cheers..

 

[sterjohn]

Hi again vcoolio,
if I have a different question, do I need to start a new thread?
New at this, sorry!
John.S

 

[vcoolio]

Hello John,

Sorry for the late reply. I didn't receive notification of your last post. Correct. You would need to start a new thread.

Cheerio,
vcoolio.

 

[sterjohn]

No trouble at all, thanks for all your help!
Take care,
John.S