View Single Post
 
Old 11-02-2017, 07:13 AM
Jo Freeman Jo Freeman is offline Windows 7 64bit Office 2016
Novice
 
Join Date: Mar 2015
Posts: 19
Jo Freeman is on a distinguished road
Default

Quote:
Originally Posted by NBVC View Post
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.
Reply With Quote