+ Reply to Thread
Results 1 to 4 of 4

Thread: Convert bytes to gigabytes

  1. #1
    Registered User
    Join Date
    05-31-2006
    Posts
    3

    Convert bytes to gigabytes

    I think that this may be more math related than anyhting but I have a colum that shows me a computers total physical memory. However this output is in terms of bytes- something like 2145374208.

    Does anyone know the proper equation to convert this number into Gigabytes? So the above example would convert to something like 2.1Gb.

    Thanks.

  2. #2
    Valued Forum Contributor
    Join Date
    07-05-2007
    Location
    Lexington, MA
    Posts
    302

    Bytes, Kilobytes, Megabytes, Gigabytes

    A Kilobyte is 1024 bytes (KB)
    A Megabyte is KB * KB = 1,048,576
    A Gigabtye is KB * KB * KB = about 1,070,000,000

  3. #3
    Valued Forum Contributor
    Join Date
    03-23-2004
    Location
    London, England
    MS-Off Ver
    MS Office Excel 2007
    Posts
    841
    Well according to Wikipedia (yep I know) a gigabyte is 1,073,741,824 bytes.
    So just divide the number you got by that amount, and use Format to reduce the amount of decimal places you want to display.
    Regards
    Special-K

    I rarely return to a problem once I've answered it so make sure you clearly define what the trouble is.

  4. #4
    Registered User
    Join Date
    09-16-2010
    Location
    tunis
    MS-Off Ver
    Excel 2003
    Posts
    1

    Re: Convert bytes to gigabytes

    Hi,

    I think this bytes converter can be very usefull to you here is the link
    http://mon-ip.awardspace.com/converter.php

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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.2.0