Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 11-06-2017, 11:43 AM
joeu2004 joeu2004 is offline Entering a number of 19 digits Windows 7 32bit Entering a number of 19 digits Office 2007
Advanced Beginner
 
Join Date: Aug 2016
Posts: 32
joeu2004 is on a distinguished road
Default

Quote:
Originally Posted by Jo Freeman View Post
to be honest, some of the discussion was way too complicated for me to understand!
And not at all relevant to your problem.

The take away is....

1. You are right: format the cell as Text first, then enter the long "number" as text.



2. Do not try to use the long "number" in an arithmetic expression; you will lose accuracy. I don't think you would: I presume the long "number" is actually an ID.
Reply With Quote
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
Entering a number of 19 digits Digits are not found in my document! reza8615953 Word 3 04-18-2017 10:48 AM
Entering a number of 19 digits 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
Entering a number of 19 digits 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:40 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft