Terms of the offer
The answer I gave hints at it. Because a calculation can’t be done in the formatting (I.e. 500,000/1,000) I used 500,000 and 500,000,000 as midpoints to determine when things should be rounded to B, MB , GB. It’s a hack, and shouldn’t be used if precision is needed. There are other things that could be done if you need more precision (custom formulas via macros, in cell formulas, named ranges, etc) In your example for Range 1, you are correct. That is the size of the memory, stated in hexidecimal, in bytes . You may gain the most insight by first converting 00FF FFFF to a decimal number, then converting that number of bytes into megabytes. To convert from bytes to megabytes use the relationship 1 MB = 1 Megabyte = 1024 " 1 KB = 1,048,576 bytes . There are tons of online Hex to Decimal converters. The calculator built in to Windows can also do the conversion. For the other ranges, you ... The term MB changed it's definition when some operating systems reported data sizes calling Mega bytes as 1,000,000 bytes which is different than what the disk manufacturers were calling Megabytes. For a variety of reasons, the industry standardized on Megabyte ( MB ) being 10^6 or 1,000,000 bytes , not 2^20 bytes . for example, sometimes i get values 50.9 MB which is good. but some other values are 37091 MB or 3082.86 MB , and i'd like values like that to be automatically converted to GB (37.09 GB, 3.08 GB respectively) if they are in the GB range.
