| Home |
| Search |
| Today's Posts |
|
#5
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 | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Stock data manipulation | Excel Worksheet Functions | |||
| ranking query | Excel Discussion (Misc queries) | |||
| Data in table, may need to convert to columns with OFFSET? | Excel Discussion (Misc queries) | |||
| How can I convert a data from multiple rows into 1 column? | Excel Worksheet Functions | |||
| convert column data into text | Excel Discussion (Misc queries) | |||
Threaded Mode
