Entering a number of 19 digits

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

FAQ

Thread Tools

Display Modes

11-02-2017, 03:12 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

Entering a number of 19 digits

Hi

I know I can't enter a number longer than 15 digits, but when I alter the cells to "Text" and enter the number, I get this:

1.23457E+17

Can someone please tell me how to get the number to show in its entirety?

Many thanks,
Jo

« Previous Thread | Next Thread »

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 03:57 AM.