Results 1 to 9 of 9

Converting Kb to Gb what is the correct formula?

This is a discussion on Converting Kb to Gb what is the correct formula? within the Excel Questions forums, part of the Question Forums category; Hello All, I have the following info in cell A: Total Storage Used -KB 5819206640 4044259328 16867651584 I want to ...

  1. #1
    Board Regular
    Join Date
    Jul 2002
    Posts
    1,267

    Default Converting Kb to Gb what is the correct formula?

    Hello All,

    I have the following info in cell A:

    Total Storage Used -KB
    5819206640
    4044259328
    16867651584

    I want to convert these to Gb. What is the correct formula please?

    Thanks,

    Kurt
    When we all learn from each other the world becomes a very great place!

  2. #2
    Board Regular
    Join Date
    Jul 2002
    Posts
    1,267

    Default Re: Converting Kb to Gb what is the correct formula?

    Would it be

    Code:
    A1/(1024*1024*1024)
    To convert Kb to Gb?
    When we all learn from each other the world becomes a very great place!

  3. #3
    c_m
    c_m is offline
    Board Regular
    Join Date
    May 2008
    Posts
    836

    Default Re: Converting Kb to Gb what is the correct formula?

    =A1/(1024^2)
    if A1 is KB, the above expression will result in GB

  4. #4
    Board Regular Barry Katcher's Avatar
    Join Date
    Feb 2002
    Location
    Dog Beach, Florida. Yeaahh!
    Posts
    4,055

    Default Re: Converting Kb to Gb what is the correct formula?

    You're not going from bytes to gigabytes, but from kilobytes to gigabytes. Just use:

    A1/(1024*1024)

    or

    A1/1,048,576.

    Correct me I'm wrong, guys.
    Barry-

    Photo Restoration/Enhancement

    http://www.smiledogproductions.com
    click below for detour


  5. #5
    Board Regular
    Join Date
    Jul 2002
    Posts
    1,267

    Default Re: Converting Kb to Gb what is the correct formula?

    Hello cm,

    Thanks that's it!

    Kurt
    When we all learn from each other the world becomes a very great place!

  6. #6
    Board Regular
    Join Date
    Jul 2002
    Posts
    1,267

    Default Re: Converting Kb to Gb what is the correct formula?

    So to get it in Terabyets it would be:

    Code:
    C32/(1024^3)
    Correct?
    When we all learn from each other the world becomes a very great place!

  7. #7
    c_m
    c_m is offline
    Board Regular
    Join Date
    May 2008
    Posts
    836

    Default Re: Converting Kb to Gb what is the correct formula?

    Quote Originally Posted by Kurt View Post
    So to get it in Terabyets it would be:

    Code:
    C32/(1024^3)
    Correct?
    Yup, you got it.

  8. #8
    Board Regular
    Join Date
    Jul 2002
    Posts
    1,267

    Default Re: Converting Kb to Gb what is the correct formula?

    Many thanks.

    Have a great weekend. Christmas and Happy New Year!

    Kurt
    When we all learn from each other the world becomes a very great place!

  9. #9
    New Member
    Join Date
    Sep 2010
    Posts
    1

    Default Re: Converting Kb to Gb what is the correct formula?

    HI

    you should see this bytes converter
    http://mon-ip.awardspace.com/converter.php

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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


DMCA.com