<div>
To be exact, you'd want to divide by 1024. The cell would look like: =A1 / 1024
</div>


To be exact, you'd want to divide by 1024. The cell would look like: =A1 / 1024

<div>
Cell format worked great, thanks!<br />
<br />
I also discovered that you can use the copy &gt;&nbsp;paste special devide option as well
</div>


Cell format worked great, thanks!

I also discovered that you can use the copy > paste special devide option as well

<div>
thanks for the points, although Harry does make a valid point, if you wanted to be precise that is.
</div>


thanks for the points, although Harry does make a valid point, if you wanted to be precise that is.

<div>
<div class="content wysiwyg-content">
Hello<br />
<br />
I have a column in Excel with serveral rows that displays hard drive capacity in Mb's<br />
<br />
Eg:<br />
<br />
46139<br />
48618<br />
48164<br />
47522<br />
53970<br />
41294<br />
50968<br />
53888<br />
34890<br />
39084<br />
<br />
<br />
How do i change the format so that it shows it in Gb's?<br />
<br />
eg:<br />
<br />
53.88<br />
39.08<br />
<br />
I think i need to devide it by 1000 but not sure how to do it<br />
<br />
Thanks
</div>
</div>


Hello

I have a column in Excel with serveral rows that displays hard drive capacity in Mb's

Eg:

46139
48618
48164
47522
53970
41294
50968
53888
34890
39084


How do i change the format so that it shows it in Gb's?

eg:

53.88
39.08

I think i need to devide it by 1000 but not sure how to do it

Thanks

Excel spreadsheet data change from Mb to Gb

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.