Converting File sizes from bytes to Kb or Mb
<p>I have got a large amount of rows with different values in it, from 1000s to 1,000,000s.</p>

<p>This is data that has come across to me in bytes and i need to convert it to Kb or Mb respectively.</p>

<p>I could divide all the values by 1M and get all the data en Mb but i want to have the data in kb and Mb. </p>

<p>I tried using the MOD function but that wont do the trick as all the numbers are going to be divisible by 1K and 1M so i am a bit stuck!</p>

<p>here is a sample of the data that i get:</p>

<pre><code>16000000
220000
2048000
2048000
230000
16000000
230000
16000000
220000
230000
</code></pre>

<p>so what i need is that if the cell contains 6 zeros then divide by 1M or if the cell contains 3 zeros devide by 1000. </p>

<p>I will add concatenation to each individual result in order to get the data differentiated.</p>