convert a column of data from Kb to MB

  • Thread starter Thread starter almostki
  • Start date Start date
A

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 !
 
Hi, if my understand was correct divide by 1024

1024kb = 1MB

hth

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



"almostki" escreveu:
 
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
 
almostki said:
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?
Click to expand...

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