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 !


--
almostki
------------------------------------------------------------------------
almostki's Profile: http://www.excelforum.com/member.php...o&userid=37659
View this thread: http://www.excelforum.com/showthread...hreadid=572651

Hi, if my understand was correct divide by 1024

1024kb = 1MB

hth

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



"almostki" escreveu:


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 !


--
almostki
------------------------------------------------------------------------
almostki's Profile: http://www.excelforum.com/member.php...o&userid=37659
View this thread: http://www.excelforum.com/showthread...hreadid=572651

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?

Thanks again!


--
almostki
------------------------------------------------------------------------
almostki's Profile: http://www.excelforum.com/member.php...o&userid=37659
View this thread: http://www.excelforum.com/showthread...hreadid=572651

almostki wrote:
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.

You don't need a macro.

Enter 1024 in an unused cell.

Copy that cell.

Select your column and EditPaste SpecialDivideOKEsc

Delete the cell with 1024


Gord Dibben MS Excel MVP


On Thu, 17 Aug 2006 11:17:47 -0400, almostki
wrote:


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?

Thanks again!

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.

almostki wrote:

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 !

--
almostki
------------------------------------------------------------------------
almostki's Profile: http://www.excelforum.com/member.php...o&userid=37659
View this thread: http://www.excelforum.com/showthread...hreadid=572651

--

Dave Peterson