Quote:
Originally Posted by NBVC
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.