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!