How to convert KB to MB in Excel?

[BillyGoat1978]

Hi All,

I am looking for a macro, step-by-step guide, etc for converting a lot of cells (well over 1000) containing data transfers for every user in KB to MB. I googled but got nothing which I can use. Any one with any knowledge on how to achive this, please help me. I have zero knowledge of VB or Java scripts and my knowledge of advanced Excel is also zero. :(

Please anyone, please help my skin from being fired.

TIA

Sumit

[Joel]

Divide KB by 1024 to get MB.

In Excel, you could put the KB in a cell (let's call it A1) and in A2 put this:

=A1/1024

Then copy the formula down by dragging the bottom right-hand corner of the cell with the formula to the end of your KB info already entered.

[martinsc]

  silly_walk said:

Divide KB by 1024 to get MB.

In Excel, you could put the KB in a cell (let's call it A1) and in A2 put this:

=A1/1024

Then copy the formula down by dragging the bottom right-hand corner of the cell with the formula to the end of your KB info already entered.

yup.... it's that easy :p

[DeleteMePlease]

could someone make a small program to convert kb 2 mb?

[ZiUL]

  KO said:

could someone make a small program to convert kb 2 mb?

there is one already... they cal it calc.exe ;)

[DeleteMePlease]

yes but a small program would be useful save opening cal. type one value and press go then you have the convertion :D :D

[cheekymonkey]

I don't have the time right now... plus all my code is on my work machine, but it is real easy in VBA. Maybe someone could rustle up something like this for ya:

Basically you select the first cell and fire off a macro which puts the formula into the cell to the right, it would then offset(1, 1) and check to see if it wasn't blank (ie, the end of the list). If it wasn't then repeat above, else go to cell A1.

I'm sorry but me busy at the mo', but it does require less than a dozen line of code and a bit of Boolean. I'll check back in here tomorrow if I can if no one has helped out already.

Sorry again,

cheeky