Entering a number of 19 digits

Jo Freeman · #3 11-02-2017, 07:13 AM

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.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Having number's digits together	mohsen.amiri	Word	0	06-23-2017 01:20 AM
Digits are not found in my document!	reza8615953	Word	3	04-18-2017 10:48 AM
Entering a number in a cell causes it to fill with the color of a nearby cell	Bill Martz	Excel	1	04-23-2015 07:57 PM
Separate the digits into 3 combinations	Jasa P	Word VBA	1	08-19-2012 11:04 PM
Problems merging in last 4 digits of an account higher than 16 digits	Glynda	Mail Merge	1	04-08-2011 12:17 AM