Converting Kb to Gb what is the correct formula?

Thanks:  0
Likes:  0

# Thread: Converting Kb to Gb what is the correct formula?

1. ## 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

2. ## Re: Converting Kb to Gb what is the correct formula?

Would it be

Code:
`A1/(1024*1024*1024)`
To convert Kb to Gb?

3. ## 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. ## 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.

5. ## Re: Converting Kb to Gb what is the correct formula?

Hello cm,

Thanks that's it!

Kurt

6. ## Re: Converting Kb to Gb what is the correct formula?

So to get it in Terabyets it would be:

Code:
`C32/(1024^3)`
Correct?

7. ## Re: Converting Kb to Gb what is the correct formula?

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

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

8. ## Re: Converting Kb to Gb what is the correct formula?

Many thanks.

Have a great weekend. Christmas and Happy New Year!

Kurt

9. ## Re: Converting Kb to Gb what is the correct formula?

HI

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

10. ## Re: Converting Kb to Gb what is the correct formula?

How to convert GB to KB in excel 2007. I have many values in GB and i need to convert the same in KB using excel formulas.

## User Tag List

#### Posting Permissions

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