Close Window
Free Ebook
Get Your Free Excel
ebook!
Top 15 Excel Tutorials from TeachExcel.com
Instant Access!
E-mail:

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 !


Free Excel Courses



Similar Excel Tutorials


Convert a column of data into multiple rows of data at a given interval. For instance, every 5 rows of data in the ...

How to convert scientific numbers to show their full amount; this method also allows you to retain the appearance o ...

Convert a table back into a regular set of cells.  This removes any automated table features and I'll show you how ...

I'll show you 4 ways to convert numbers stored as text to numbers in Excel.  This situation often happens when you ...


Helpful Excel Macros


- Convert a numeric dollar amount into its text equivalent. This UDF (user defined function) for Excel will change or tra

- This macro will convert every formula in an entire workbook into its respective value. This is basically a quick way to

- This macro reverses the order of a selected row or column in excel. It will completely reverse the data.

- Macro that sorts data that has headers in ascending order in Excel. This macro assumes that you data has headers on it.

- This Excel macro filters data in Excel without the filter "arrow" appearing in the column that is being filtered. This

Similar Topics







i've been trying to figure this out on my own but seem to be hitting road blocks.

i have a column of numbers that we extracted from a database as whole numbers. for instance, 30 should be .30 and 100 should be 1.00. when i try to increase or decrease the decimal point it doesn't allow me to convert it to those positions.

would any one have a tip of how i can easily convert this? there are over 2000 entries in my excel spreadsheet so to do it manually would take a lot of time/effort.

thank you!


Hi guys,

would really appreciate anyones help with this.

I have a column full of text-formatted fractions...

4/5
6/4
3/1
2/5
4/5

etc, etc.....the column is very long!!

I need to convert these to actual fractions...ones I can add to equations, allowing me to multiply and add.

If I highlight the column and goto "format Cells" and change to fraction, the values still stay in the left of the cell.....its only when I manually click on each individual cell, then tick the little green tick, does the cell validate, and the value in the cell moves to the right (and is therefore a proper value).....problem is I have to keep doing this for each individual cell.....and I have 70000+ cells in this column!

Any suggestions on how I could speed this up?

thanks


In excel, I tried to convert numbers to number format, using
format/cells/number from the category list. But it won't take, and stays
text-like. Any ideas?



I was able to convert start date and and end date to the number of days
inbetween the two dates. Does anyone know how to then convert the number of
days into months?



Hi,
I made a simple worksheet that we have been manually entering the time for employees, but there are too many errors (even with simple math). Can someone help me convert the time of ex: written 8-4:30 or 10-3 (meaning 8:00am to 4:30pm) where you have the total weekly hours? Right now I have a column for overtime. Is there a way to automatically calculate the over time also? The work day is 8-4:30 with a half hour lunch (lunch is not calculated into the hours, so you minus a half hour). 8-4:30 equals 8 hours. So, if a person works 8am to 6:30pm, how can I set it up where in the first row of time, I will type in 8-6:30pm. In the totals column to the far right, it will display 8 hours. In the (O.T.) column, it will display 2 hours.

This way, when I call in my payroll, I will have the total "regular" hours in one row and underneath, I will have the total overtime hours.

Or... does anyone have a better solution to keeping track of their hours?

Thanks!
Marty


Hi there. I'm using Excel 2007 and often use filters to find inconsistent data (mis-spellings, etc.) and then clean up the data using the fill handle to fill in correctly formatted values. I'm finding that, with a simple filter on, dragging over cells hidden by the filter changes the values in the hidden cells too. This is something I don't remember from my last version of Excel. I'm wondering if I've mis-remembered how this control works, or if there is a setting I can't find.

My goal is to drag and fill (or paste) in a colum with a range of rows wiht some hidden (filtered out) rows, and have the filtered out data be unaffected, if that makes sense.

Thanks!

T


I am looking for assistance in having one cell in a text format equals another cell that contains a time value in hh:mm format.

For example: Cell A1 has a time format (hh:mm) value of 04:00; which is the Start Time. I would like cell D1 to have a text format value of "04:00" (result is dependant upon what is entered in A1). I would duplicate the same formulas to reflect Stop Times in other cells.

My final result is to have another cell (F1) use the Concatenate formula to have the Start and Stop time shown in one cell as "04:00 - 12:30". The times would change based on the Time formated values entered into the Start and Stop time cells.

I have researched this in the board and found many excellent ways to do the opposite, but not convert Time format to Text format. Any assistance is greatly appreciated.

-Shane


I have data with time in standard fromat i.e. 3:00PM but I need it to be in
24 hour format i.e. 15:00. How can I do this?



i know how to use the data filters vertically but have been wondering if its possible to filter data horizontally so i could put a filter on, say column c and sort the data across the sheet rather than down. if its not possible i will find another way to do what i want but this seems to be just what i would need. does anyone know if it can be done?


Hello,

I'm pretty new at VBA and was wondering if you could help me out on this:

I have created a VBA userform but will need to have it used by at least 5 users. My question is, can it be done with all users working at the same time and when saving their work all data entered will go to one master excel sheet? if yes, would you be kind enough to share the code?
MS Access is not an option for me so I was wondering if you could help me do this in excel.

thank you so much and would really appreciate to hear from anyone soon.

My balance sheet is prepared in rupees.
I want to show all figures in Lacs like value 235600 show 23.56

In previous year i divided all values one by one by inputting /100000 but its so tedious.
Pl help.


Hi there,

How i can convert Hijra (Islamic) Dates into Gregorian?

a formula or VB

any help


I've been poking around trying to figure this out but can't. The time of 9 hours, 15 minutes is being returned from a calculation but I want the cell to display the 9.25 hours instead. This seems like something simple on the surface, but apparently it's not. Any help would be appreciated!


Good afternoon,

Is there a way to enter a colon into a standard number to create a value that can be formatted into a 24 hour time value ?

eg a time is listed as 1345 with a general number format, and I want it returned as 13:45 witha custom format of hh:mm.

Other than creating a table and using a vlookup function, I am hoping there is a better way?

Darren


I have a given length of steel bar...Example(550 feet)
I have various cut lengths that I can pick from...
14'-10".....13'- 9".. 12'-8"........(up to 6 different lengths)

I need to know the best combination of lengths to cut the long bar into to have minimal scrap left when we get to the end of the 550 feet.....

Cut as many of the longest cut lengths possiable.....Cut as few of the shortest cut lengths possiable

Due to the fact that I will have to convert this to a PLC application when completed, I want to find a mathmatical way to do this inside excel and not use the "solver"....Assuming that I/we can come up with an equation to do this .....
Any and all advice/help would be appricated.....


I use Excel 2000 (9.0.2720)

In range A1:D10, I have entered the figures in actuals (e.g. 34532642.45,
78945624.89 etc.). How can I convert those figures in Lakhs / Thousands /
Crores? Before converting, Can Excel 2000 prompt me for conversion in Lacs /
Thousands / Crores?



Does anyone know if there is a customer format I can use to change the percent value of a cell to basis points? I tried creating my own, but was having difficulty. For example, if the cell value in A1 is 2%, I would like to have it say 200 basis points instead.

Thanks.


Newbie here and I don't know where to start... I'm trying to set up a macro to when data is pasted to a TEMPLATE worksheet tab it will automatically copy and paste data to another sheet based on the month value.
For example:
If data contains 06/01/2011 in cell A1, then data needs to be pasted to "Jun" worksheet within the same workbook.

Can someone assist or can give some direction? Thank you


Hi everyone, this is my first post here. I consider myself a more advanced Excel user and can navigate my way around fairly well. I've written a spreadsheet and am wondering if there is a way to permit data entry in a cell, contingent upon another cell being populated.

In simple terms, you can't enter data in cell X, until cell "Y" has been populated with something.

Can anyone help with this, because I can't figure it out....


I was wondering if there is a way of getting a macro to open the "save as" dialogue box and then have it fill in the "file name" field.

I dont want it to actually make the save though as I want the user to have the chance to check that the save location is correct and the option to change the filename if required.

Cheers.


Hi,

I have a long list of data validation. I was wondering if there is a way when I clik on the drop down menu and type the first letter, automatically Excel shows all list with that letter.

Right now, I have to click on the drop down menu and scroll manually until I reach that desired list.

Thanks.


I have an excel form, I want my users to be able to open the form, fill in appropriate data, then click the save button. When the button is clicked, the data in the form should be saved to a new file and then the original form should be reset (clear all values) for a new set of data entry. When the data is saved, I want the new excel sheet to be saved to a location specified within the macro so the user doesn't have any options and I want the title of the new file to be the value of one of the cells.

I'm new to macros and would appreciate any help this board can offer. Thanks...


Hello,

I'd like to be able to copy data from a list of websites into Excel. It would take too long to navigate to do an Excel web query for each site, so is it possible to write a macro that could do that?

Thank you!

ML


Hi,

How can I reset where Excel thinks the end of may data is?

When I press Ctrl+End it highlishts column ANC when really my data now finished at Column AC

thanks


Hello

I am trying to understand why I can not use Ctrl+F to find data in Column B, yet I can find the data in Column A.

I have a worksheet that in column A has numbers, in column B, the following formula "IF(ISNUMBER($A1),$A1,"").

Ctrl+F will find numbers in Column A, yet not in Column B. Why is this so? What can be done to ensure Ctrl+F works in Column B?



Related pages


how to calculate compounding interest in excelvba create drop down listexcel count based on cell colorhow to solve matrix in excelexcel macro concatenatefloating bar graph excelhow to arrange excel sheet in ascending orderexcel vba modeless userformremove activex controlcount workdays excelpst convert to estweight loss percentage spreadsheetinterest rate formula excellinking workbooks in excelxll filesorting numbers in excelascending order in excel 2007vba execute sqlcst to ist timingsmsgbox options00020813 0000 0000 c000 000000000046autocomplete as it applies to excelxls vlookupconditional formatting in powerpointhow to run sql query in excelcombine multiple columns in excelrun time error 57121excel vba rename filecalculating age from birthdate in excelhow to use mmult in excellitres per 100km formulahow to highlight duplicates in excel 2003one slicer for two pivot tablesconversion kilos to stoneskb to gb translatorcreate drop down list in excel 2003excel macro remove blank rowsvba calling a subcst to ist converterwhat is the shortcut key for merge cells in excelstaffing calculator exceltrapezoidal rule excelcagr equation excelstacked bar chart excel 2010convert litres to miles per galloncube root in excel3rd degree polynomialsstraight line depreciation excelformula for calculating cagr in excelvba scatter plotvsflex3.ocxhow to build a timesheet in excelexcel subnet calculatorcall log spreadsheetvba line feed characterp value linear regression excelsubtract two dates in excelexcel wrap text shortcutsumif date rangeexcel function weekdaycompare two excel spreadsheets for matches8.00 am cst to istrow height excel 2010highlight every other row in excelprorated invoicerun regression excelexcel cannot open file extension not validlinear depreciation formulaexcel how to remove password protection 2010excel columns missingclustered stacked chartrandom sort in excelreturn month name in excelexcel application statusbarhow to set up a tickler fileexcel vba isempty