Convert number into MB/GB format. Need help thanks

[pedie]

How do I convert this number below in to MB/GB <TABLE style="WIDTH: 63pt; BORDER-COLLAPSE: collapse" border=0 cellSpacing=0 cellPadding=0 width=84><COLGROUP><COL style="WIDTH: 63pt; mso-width-source: userset; mso-width-alt: 3072" width=84><TBODY><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; WIDTH: 63pt; HEIGHT: 15pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" height=20 width=84 align=right>18603576050</TD></TR></TBODY></TABLE>


Pedie!

 

[pedie]

How do I convert this number below in to MB/GB <TABLE style="WIDTH: 63pt; BORDER-COLLAPSE: collapse" border=0 cellSpacing=0 cellPadding=0 width=84><COLGROUP><COL style="WIDTH: 63pt; mso-width-source: userset; mso-width-alt: 3072" width=84><TBODY><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; WIDTH: 63pt; HEIGHT: 15pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" height=20 width=84 align=right>18603576050</TD></TR></TBODY></TABLE>
Pedie!

The answer should be 17.3 GB

But i dont know how to convert this number that is soo hugh...

 

[VoG]

Try

Excel Workbook
	A	B	C
1	Bytes	MB	GB
2	18603576050	17741.75267	17.32593034
Sheet3

 

[Smitty]

Well, here's the base conversion:

1 Kilobyte = 0.0009765625 OR 1/1024 Megabytes

1 Byte = 8 Bit
1 Kilobyte = 1024 Bytes
1 Megabyte = 1048576 Bytes
1 Gigabyte = 1073741824 Bytes

So MBytes would be: =A1/1048576
GBytes would be: =A1/1073741824

HTH,

EDIT: not fast enough for Peter.

 

[Datsmart]

Yes, Peter is fast;

Excel Workbook
	A	B	C
1	Bytes	MB	GB
2	18603576050	17741.75	17.32593
Sheet

 

[VoG]

I forgot to mention that whilst the formulas above use a factor of 1024, hard drive manufacturers commonly round that to 1000. A bit like the American state that declared that the value of pi is 3 instead of 3.1415926... (or is that an urban myth?).

 

[pedie]

Thanks everyone...see how ignorant i am now.


Thanks again!

 

[VoG]

see how ignorant i am now.

You aren't ignorant now since you had the common sense to ask when you didn't know the answer. We can't be expected to know everything about Excel or anything else.

 

[pedie]

Thank Vog!!!

Always supportive as usual!!!

Pedie

 

[Smitty]

A bit like the American state that declared that the value of pi is 3 instead of 3.1415926... (or is that an urban myth?).

Sounds like something idiotic enough to have happened right here in Nuts'afornia.