Converting Kb to Gb what is the correct formula?

[Kurt]

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

 

[Kurt]

Would it be

A1/(1024*1024*1024)

To convert Kb to Gb?

 

[c_m]

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

 

[Barry Katcher]

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.

 

[Kurt]

Hello cm,

Thanks that's it!

Kurt

 

[Kurt]

So to get it in Terabyets it would be:

C32/(1024^3)

Correct?

 

[c_m]

So to get it in Terabyets it would be:

C32/(1024^3)

Correct?

Yup, you got it.

 

[Kurt]

Many thanks.

Have a great weekend. Christmas and Happy New Year!

Kurt

 

[yacoubi]

HI

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

 

[Devaraju1973]

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.

Please help.