Entering a number of 19 digits

		Microsoft Office Forums > Microsoft Excel > Excel
Entering a number of 19 digits

11-02-2017, 07:15 AM

Jo Freeman Jo Freeman is offline

Windows 7 64bit Entering a number of 19 digits

Office 2016

Novice

Join Date: Mar 2015

Posts: 19

Actually, I have just had an epiphany! You need to make sure the cell is a Text cell before entering a long number. You can't alter it afterwards.

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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

Other Forums: Access Forums

All times are GMT -7. The time now is 06:56 AM.