+ Reply to Thread
Results 1 to 2 of 2

Number formatting

  1. #1
    Registered User
    Join Date
    06-03-2014
    Posts
    2

    Number formatting

    How do I convert this number 8.989E+19 (which was extracted from a website) to a csv file to this 89440000000016448260. If I convert it to then the last 8 to 10 digits become zero's
    Last edited by Keith Gold; 06-03-2014 at 10:21 AM.

  2. #2
    Forum Expert daffodil11's Avatar
    Join Date
    07-11-2013
    Location
    Phoenixville, PA
    MS-Off Ver
    MS Office 2016
    Posts
    4,465

    Re: Number formatting

    Because Excel uses floating point precision, it will never store a numeric value beyond 15 digits.

    You can technically copy the number into a cell after ' and it will store the value as a text string, but if you attempt any sort of calculation against it, it will instantly convert the remaining digits into zero.

    You may wish to search for software designed to handle arbitrary point precision.
    Make Mom proud: Add to my reputation if I helped out!

    Make the Moderators happy: Mark the Thread as Solved if your question was answered!

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Number Formatting and Conditional Formatting
    By morayman in forum Excel General
    Replies: 1
    Last Post: 01-23-2014, 04:03 AM
  2. [SOLVED] Formatting to make 2 digit number show up at 3 digit number.
    By cadamhill in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-18-2012, 06:58 PM
  3. Conditional Formatting quirk with Number formatting
    By ChemistB in forum Excel General
    Replies: 9
    Last Post: 07-20-2011, 08:44 AM
  4. Replies: 3
    Last Post: 02-12-2009, 01:08 PM
  5. formatting cell number based on previous cell number
    By Pasquini in forum Excel General
    Replies: 3
    Last Post: 06-20-2006, 01:40 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1