Results 1 to 5 of 5

Converting large numbers into binary

Threaded View

  1. 03-01-2014, 12:14 AM #1
    excelerat8r
    excelerat8r is offline
    Registered User
    Join Date
    03-01-2014
    Location
    America
    MS-Off Ver
    Excel 2010
    Posts
    1

    Converting large numbers into binary

    My task is to convert 4503599627370495 into binary. Haven't had any luck with DEC2BIN() due to the number's size. Not only is dec2bin an issue, excel doesn't easily handle the number because it is one too many significant digits. Excel recognizes the number above as 4503599627370490. Any ideas?
    Last edited by excelerat8r; 03-01-2014 at 12:18 AM.
    Reply With QuoteRegister To Reply
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. large binary numbers
    By Barb Reinhardt in forum Excel Formulas & Functions
    Replies: 13
    Last Post: 09-06-2005, 06:05 PM
  2. large binary numbers
    By Himu in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 10:05 AM
  3. large binary numbers
    By Barb Reinhardt in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 09-06-2005, 07:05 AM
  4. large binary numbers
    By Himu in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 03:05 AM
  5. [SOLVED] large binary numbers
    By Himu in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 01:05 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1