convert a column of data from Kb to MB

[almostki]

Hi all,

Thank you for reading this, I was wondering if it was possible to have
a macro convert a colum of data from Kb to MB ? Thanks !

 

[Guest]

Hi, if my understand was correct divide by 1024

1024kb = 1MB

hth

--
regards from Brazil
Thanks in advance for your feedback.
Marcelo



"almostki" escreveu:

 

[almostki]

thanks! but i am very new to excel, how would i set this up as a macr
to go down the colum and turn all of the numbers to mb?

Thanks again

 

[joeu2004]

thanks! but i am very new to excel, how would i set this up as a macro
to go down the colum and turn all of the numbers to mb?

Would it be helpful to know that you do not need to use a macro?

Alternatively, you can do the following:

1. Put the number 1024 into a cell.
2. Copy that cell (right-click, select Copy).
3. Select the range of cells to be changed.
4. Right-click, select Paste Special > Divide.

 

[Dave Peterson]

You don't need a macro.

Put 1024 in an empty cell.
edit|copy that cell
select the range of numbers to convert
edit|Paste special|check divide

clean up that cell with 1024 in it.

 

[Gord Dibben]

You don't need a macro.

Enter 1024 in an unused cell.

Copy that cell.

Select your column and Edit>Paste Special>Divide>OK>Esc

Delete the cell with 1024


Gord Dibben MS Excel MVP