Skip to content
Skip to content
Menu
Alchemex
  • Products
    • Sage Intelligence Reporting
      • Enrolment
    • Velixo
      • Enrolment
        • Velixo for Acumatica
        • Velixo for Sage Intacct
  • Services
    • Consulting
    • Training
    • Development
  • Support
    • Support Overview
    • Create Support Ticket
    • Book A Session
    • Knowledgebase
  • About
    • About Us
  • Contact
Alchemex

How to work with numbers containing more than 15 digits in Excel

By admin on September 29, 2017April 19, 2019

Numbers containing more than 15 digits in Excel are not often used, however some users might use them when recording credit card numbers, account numbers, stock codes, etc.
Applies To: Microsoft® Excel® for Windows 2013 and 2016.
Excel can’t handle more than 15 digits per cell, and so when these numbers are entered, Excel stores the first 15 digits and replaces all remaining digits with zeros.
For example; the number 1234567891234567 is stored as 1234567891234560
   
As these large numbers are NOT going to be used in a calculation, the issue is easily resolved, by simply formatting the cell to Text before entering the numbers.
Here’s how to do it:
Select the cells of the columns where the numbers will be stored.
On the Home tab, select the Number Format drop-down.

Scroll all the way to the bottom of the list and select Text.

Enter required numbers as usual.

A note to remember: if you copy and paste numbers from a different area to these formatted cells, you’ll need to use Paste Special Values or Paste as Text to retain the Text format in the cells. However, if used correctly, this will enable you to use more than 15 digits in Excel.
The post How to work with numbers containing more than 15 digits in Excel appeared first on Sage Intelligence.

Powered by WPeMatico

Post navigation

Making use of Wildcards in your Reporting Trees
Using Microsoft Excel as a Data Source in Sage Intelligence

Recent Posts

  • Why Working In Excel Works
  • Alchemex Welcomes Velixo 6 For MYOB Advanced
  • Welcome to Velixo Reports Version 4.2
  • Part 3 of 3: Learn how to create a Management Pack in Sage 50cloud Intelligence
  • Part 3 of 3: Create and customize reports easily with the Financial Report Designer

Search

Contact Us

Phone: +61 2 9890 2339
Email: sales@alchemex.com.au
Address: PO Box 212, Deaken West, Canberra, Australia, 2600
©2025 Alchemex | WordPress Theme by SuperbThemes.com