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