What KB To MB Conversion Formula In Excel?

Asked By Gerald S Osborne 0 points N/A Posted on - 01/19/2018

Hello everyone, I am working in Excel and have lots of values in kb which need to be converted in mb. Please provide me the formula for KB to MB conversion formula in Excel. Thanks in advance for the help.

• Status: Open
• Question Views: 627
• Answer Count: 2
• Vote Up 0 Vote Down

• Answer Accepted: No
• Question Category: Software Others
• Question Tags: Excel

Answered By Andrew Kurt 0 points N/A #307933

What KB To MB Conversion Formula In Excel?

First, populate your sheet with the data and values you have.

Next, select the range of the data you want to convert. Click on Kutools and choose for content and then go for the unit conversion.

Specify the units you want to convert.

Hit on Apply and then OK.

You can also use the division of the kb from 1024 to convert it into MB.

About Andrew Kurt

Questions
1

Answers
30

Best Answers
16

• Vote Up 0 Vote Down

• Posted on - 01/19/2018
• Question Category: Software Others

Answered By Sharath Reddy 590495 points N/A #308351

What KB To MB Conversion Formula In Excel?

If your version of Microsoft Office Excel is equipped with Kutools, converting from KB to MB would be easy. But if you are using an older version that doesn’t come with Kutools like Microsoft Office Excel 2007 and earlier, you probably have to do the calculations manually by entering the formula in the cell. To convert KB to MB, this formula is used: MB = KB / 1,024.

For example, to convert 800 KB to MB, you will have:

MB = KB / 1,024
MB = 800 / 1,024
MB = 0.78125

This means 800 KB is equal to 0.78125 MB. Now, if you want to do the reverse and convert MB to KB, this formula is used: KB = MB x 1,024. KB is the shortened term for Kilobyte or kilobyte while MB is for megabyte or Megabyte. These units are used to measure digital storage based on “Binary multiples of Bytes.”

For kilobyte, you can use KB or KiB for its symbol and there are 1,024 kilobytes in a megabyte. For megabyte, you can use MB or MiB and there are 0.0009765625 megabytes in a kilobyte.

About Sharath Reddy

Questions
1

Answers
14599

Best Answers
2290

• Vote Up 0 Vote Down

• Posted on - 02/15/2018
• Question Category: Software Others