|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
August 17th, 2006, 03:33 PM
posted to microsoft.public.excel.misc
|
|||
|
|||
convert a column of data from Kb to MB
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 
|
|
#2
August 17th, 2006, 04:14 PM
posted to microsoft.public.excel.misc
|
|||
|
|||
|
convert a column of data from Kb to MB
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
|
|
#3
August 17th, 2006, 04:17 PM
posted to microsoft.public.excel.misc
|
|||
|
|||
|
convert a column of data from Kb to MB
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
|
|
#4
August 17th, 2006, 05:03 PM
posted to microsoft.public.excel.misc
|
|||
|
|||
|
convert a column of data from Kb to MB
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.
|
|
#5
August 17th, 2006, 05:04 PM
posted to microsoft.public.excel.misc
|
|||
|
|||
|
convert a column of data from Kb to MB
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
|
|
#6
August 17th, 2006, 05:42 PM
posted to microsoft.public.excel.misc
|
|||
|
|||
|
convert a column of data from Kb to MB
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!
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
