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