Are you sure the format of the cell is text? If it is then it would work.

Hi NBVC

This is really strange. I entered the 19-digit number and clicked on Format, Format Cells, Number, Text and the above result appeared.

When I altered another cell to Text, using the dropdown box on the Home tab, and entered the number it worked fine.

Don't understand the difference there, but I am getting the result I want using the second method.

Thank you for your reply.