blocks|key|1436439|text|我不知道有什么方法可以让它显示二进制‘t(1024*1024*1024的倍数)，但您可以使用如下格式让它显示十进制’t：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1436440|0.00,,,"Gb"|code-block|syntax|javascript|1436441|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

I don't know of a way to make it show you binary gigabytes (multiples of 1024*1024*1024) but you can make it show you decimal gigabytes using a format like:

<pre><code>0.00,,,"Gb"
</code></pre>

blocks|key|1436476|text|您实际上不能在Excel的格式设置功能中进行计算。不过，您可以使用类似以下内容的内容来进行粗略估计：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1436477|[<500000]#,##0"+B";[<500000000]#,##0,,"+MB";#,##0,,,"+GB"|code-block|syntax|javascript|1436478|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

You can't really do calculations in the formatting features of Excel. You can use something like the following to do a rough estimation though:

<pre><code>[&lt;500000]#,##0" B";[&lt;500000000]#,##0,," MB";#,##0,,," GB"
</code></pre>

blocks|key|1221558|text|这是我一直在使用的一个：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1221559|[<1000000]0.00,"+KB";[<1000000000]0.00,,"+MB";0.00,,,"+GB"|code-block|syntax|javascript|1221560|似乎工作得很好。|1221561|entityMap^0|0|0|0^^$0|@$1|2|3|4|5|6|7|K|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|L|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|M|8|@]|9|@]|A|$]]|$1|I|3|-4|5|6|7|N|8|@]|9|@]|A|$]]]|J|$]]

Here is one that I have been using: -

<pre><code>[&lt;1000000]0.00," KB";[&lt;1000000000]0.00,," MB";0.00,,," GB"
</code></pre>

Seems to work fine.

blocks|key|1221645|text|稍作更改，使其在我所在的地区，欧洲(.作为千位分隔符，逗号作为小数分隔符)：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1221646|[<1000000]#.##0,00"+KB";[<1000000000]#.##0,00.."+MB";#.##0,00..."+GB"|code-block|syntax|javascript|1221647|数据转换的问题仍然是一样的(1000+!=+1024)，但它为我做了这项工作。|1221648|entityMap^0|0|0|0^^$0|@$1|2|3|4|5|6|7|K|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|L|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|M|8|@]|9|@]|A|$]]|$1|I|3|-4|5|6|7|N|8|@]|9|@]|A|$]]]|J|$]]

Slight change to make it work on my region, Europe (. as thousands separator, comma as decimal separator):

<pre><code>[&lt;1000000]#.##0,00" KB";[&lt;1000000000]#.##0,00.." MB";#.##0,00..." GB"
</code></pre>

Still same issue on data conversion (1000 != 1024) but it does the job for me.

blocks|key|1221680|text|在看到这里的答案后，只需对此公式进行改进，使其在较大值上具有小数位，并满足负值。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1221681|=IF(A1<999500000000,TEXT(A1,"#,##.#0,,,""+TB"""),
IF(A1<-9995000000,TEXT(A1,"#,##.#0,,,""+GB"""),
IF(A1<-9995000,TEXT(A1,"#,##0,,""+MB"""),
IF(A1<-9995,TEXT(A1,"#,##0,""+KB"""),
IF(A1<-1000,TEXT(A1,"#,##0""+B+"""),
IF(A1<0,TEXT(A1,"#,##0""+B+"""),
IF(A1<1000,TEXT(A1,"#,##0""+B+"""),
IF(A1<999500,TEXT(A1,"#,##0,""+KB"""),
IF(A1<999500000,TEXT(A1,"#,##0,,""+MB"""),
IF(A1<999500000000,TEXT(A1,"#,##.#0,,,""+GB"""),
TEXT(A1,"#,##.#0,,,,""+TB""")))))))))))|code-block|syntax|javascript|1221682|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

After seeing the answers here just improved on this formula to have decimal places on bigger values and cater for negative values.

<pre><code>=IF(A1&lt;999500000000,TEXT(A1,"#,##.#0,,,"" TB"""),
IF(A1&lt;-9995000000,TEXT(A1,"#,##.#0,,,"" GB"""),
IF(A1&lt;-9995000,TEXT(A1,"#,##0,,"" MB"""),
IF(A1&lt;-9995,TEXT(A1,"#,##0,"" KB"""),
IF(A1&lt;-1000,TEXT(A1,"#,##0"" B """),
IF(A1&lt;0,TEXT(A1,"#,##0"" B """),
IF(A1&lt;1000,TEXT(A1,"#,##0"" B """),
IF(A1&lt;999500,TEXT(A1,"#,##0,"" KB"""),
IF(A1&lt;999500000,TEXT(A1,"#,##0,,"" MB"""),
IF(A1&lt;999500000000,TEXT(A1,"#,##.#0,,,"" GB"""),
TEXT(A1,"#,##.#0,,,,"" TB""")))))))))))
</code></pre>

blocks|key|1436706|text|少于TB的写入容量为GB，超过999+GB的写入容量为TB|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1436707|<10000“GB";>9990.0，”TB“|1436708|或|1436709|<10000“GB";>=10000.0，”TB“|1436710|entityMap^0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|J|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|K|8|@]|9|@]|A|$]]|$1|D|3|E|5|6|7|L|8|@]|9|@]|A|$]]|$1|F|3|G|5|6|7|M|8|@]|9|@]|A|$]]|$1|H|3|-4|5|6|7|N|8|@]|9|@]|A|$]]]|I|$]]

<h1>Less than Tera will write on GB &amp; more than 999 GB write on TB</h1>

[&lt;1000]0" GB";[>999]0.0," TB"

OR

[&lt;1000]0" GB";[>=1000]0.0," TB"

blocks|key|1221795|text|上述公式的第一行需要一个减号："=IF(A1<-999500000000“|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1221796|=IF(A1<-999500000000,TEXT(A1,"#,##.#0,,,""+TB"""),
IF(A1<-9995000000,TEXT(A1,"#,##.#0,,,""+GB"""),
IF(A1<-9995000,TEXT(A1,"#,##0,,""+MB"""),
IF(A1<-9995,TEXT(A1,"#,##0,""+KB"""),
IF(A1<-1000,TEXT(A1,"#,##0""+B+"""),
IF(A1<0,TEXT(A1,"#,##0""+B+"""),
IF(A1<1000,TEXT(A1,"#,##0""+B+"""),
IF(A1<999500,TEXT(A1,"#,##0,""+KB"""),
IF(A1<999500000,TEXT(A1,"#,##0,,""+MB"""),
IF(A1<999500000000,TEXT(A1,"#,##.#0,,,""+GB"""),
TEXT(A1,"#,##.#0,,,,""+TB""")))))))))))|code-block|syntax|javascript|1221797|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

Above formula requires a minus sign in the first line: "=IF(A1&lt;-999500000000" 

<pre><code>=IF(A1&lt;-999500000000,TEXT(A1,"#,##.#0,,,"" TB"""),
IF(A1&lt;-9995000000,TEXT(A1,"#,##.#0,,,"" GB"""),
IF(A1&lt;-9995000,TEXT(A1,"#,##0,,"" MB"""),
IF(A1&lt;-9995,TEXT(A1,"#,##0,"" KB"""),
IF(A1&lt;-1000,TEXT(A1,"#,##0"" B """),
IF(A1&lt;0,TEXT(A1,"#,##0"" B """),
IF(A1&lt;1000,TEXT(A1,"#,##0"" B """),
IF(A1&lt;999500,TEXT(A1,"#,##0,"" KB"""),
IF(A1&lt;999500000,TEXT(A1,"#,##0,,"" MB"""),
IF(A1&lt;999500000000,TEXT(A1,"#,##.#0,,,"" GB"""),
TEXT(A1,"#,##.#0,,,,"" TB""")))))))))))
</code></pre>

blocks|key|1436829|text|上述格式化方法有效，但仅适用于三个级别。上面使用的是KB、MB和GB。在这里，我将其扩展到6个。右键单击单元格，然后选择格式化单元格。在Number选项卡下，选择Custom。然后在Type:框中输入以下内容：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1436830|[<1000]##0.00"++B";[<1000000]##0.00,"+KB";##0.00,,"+MB"|code-block|syntax|javascript|1436831|然后选择OK。这包括B、KB和MB。然后，在选定相同单元格的情况下，依次单击常用功能区、条件格式、新建规则。选择仅设置包含的单元格的格式。然后在下面的规则描述中，只设置单元格的格式，单元格值大于或等于1000000000+(即9个零)。然后单击Format、Number选项卡、Custom，并在Type:框中输入以下内容：|1436832|[<1000000000000]##0.00,,,"+GB";[<1000000000000000]##0.00,,,,"+TB";#,##0.00,,,,,"+PB"|1436833|选择OK，然后选择OK。只有当值大于1,000,000,000时，此条件格式才会生效。它将处理GB、TB和PB范围。|1436834|567.00++B
++5.67+KB
+56.70+KB
567.00+KB
++5.67+MB
+56.70+MB
567.00+MB
++5.67+GB
+56.70+GB
567.00+GB
++5.67+TB
+56.70+TB
567.00+TB
++5.67+PB
+56.70+PB|1436835|任何大于PB的数据都会显示为更大的PB，例如56,700+PB。您可以添加另一个条件格式来处理更大的值、EB等等。|1436836|entityMap^0|0|0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|S|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|T|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|U|8|@]|9|@]|A|$]]|$1|I|3|J|5|D|7|V|8|@]|9|@]|A|$E|F]]|$1|K|3|L|5|6|7|W|8|@]|9|@]|A|$]]|$1|M|3|N|5|D|7|X|8|@]|9|@]|A|$E|F]]|$1|O|3|P|5|6|7|Y|8|@]|9|@]|A|$]]|$1|Q|3|-4|5|6|7|Z|8|@]|9|@]|A|$]]]|R|$]]

The above formatting approach works but only for three levels. The above used KB, MB, and GB. Here I've expanded it to six. Right-click on the cell(s) and select Format Cells. Under the Number tab, select Custom. Then in the Type: box, put the following:

<pre><code>[&lt;1000]##0.00" B";[&lt;1000000]##0.00," KB";##0.00,," MB"
</code></pre>

Then select OK. This covers B, KB, and MB. Then, with the same cells selected, click Home ribbon, Conditional Formatting, New Rule. Select Format only cells that contain. Then below in the rule description, Format only cells with, Cell Value, greater than or equal to, 1000000000 (that's 9 zeros.) Then click on Format, Number tab, Custom, and in the Type: box, put the following:

<pre><code>[&lt;1000000000000]##0.00,,," GB";[&lt;1000000000000000]##0.00,,,," TB";#,##0.00,,,,," PB"
</code></pre>

Select OK, and OK. This conditional formatting will take over only if the value is bigger than 1,000,000,000. And it will take care of the GB, TB, and PB ranges. 

<pre><code>567.00 B
 5.67 KB
 56.70 KB
567.00 KB
 5.67 MB
 56.70 MB
567.00 MB
 5.67 GB
 56.70 GB
567.00 GB
 5.67 TB
 56.70 TB
567.00 TB
 5.67 PB
 56.70 PB
</code></pre>

Anything bigger than PB will just show up as a bigger PB, e.g. 56,700 PB. You could add another conditional formatting to handle even bigger values, EB, and so on.

blocks|key|1436884|text|还有另一种解决方案，就是使用工程符号。(这与科学记数法类似，只是指数始终是3的倍数。)右键单击单元格，然后选择格式化单元格。在Number选项卡下，选择Custom。然后在Type:框中输入以下内容：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1436885|##0.00E%2B00|code-block|syntax|javascript|1436886|然后单击OK。而不是K，M等，你将有%2B3，%2B6等。这将适用于正数和负数，以及正负指数，-3是M，-6是u，等等。|1436887|567.00E-06
++5.67E-03
+56.70E-03
567.00E-03
++5.67E%2B00
+56.70E%2B00
567.00E%2B00
++5.67E%2B03
+56.70E%2B03
567.00E%2B03
++5.67E%2B06|1436888|entityMap^0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|M|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|N|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|O|8|@]|9|@]|A|$]]|$1|I|3|J|5|D|7|P|8|@]|9|@]|A|$E|F]]|$1|K|3|-4|5|6|7|Q|8|@]|9|@]|A|$]]]|L|$]]

And, yet another solution, is to use engineering notation. (That's like scientific notation except the exponent is always a multiple of 3.) Right-click on the cell(s) and select Format Cells. Under the Number tab, select Custom. Then in the Type: box, put the following:

<pre><code>##0.00E+00
</code></pre>

Then click OK. Instead of K, M, etc, you'll have +3, +6, etc. This will work for positive and negative numbers, as well as positive and negative exponents, -3 is m, -6 is u, etc.

<pre><code>567.00E-06
 5.67E-03
 56.70E-03
567.00E-03
 5.67E+00
 56.70E+00
567.00E+00
 5.67E+03
 56.70E+03
567.00E+03
 5.67E+06
</code></pre>

blocks|key|1436959|text|这有点“蛮力”，但很管用;)|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1436960|=IF(E4/1000<1;CONCATENATE(E4;"+bps");IF(E4/1000<1000;CONCATENATE(ROUND(E4/1000;2);"+kbps");IF(E4/1000000<1000;CONCATENATE(ROUND(E4/1000000;2);"+mbps");IF(E4/1000000000<1000;CONCATENATE(ROUND(E4/1000000000;2);"+gbps")))))|code-block|syntax|javascript|1436961|​|1436962|📷|atomic|offset|length|1436963|1436964|entityMap|0|IMAGE|mutability|IMMUTABLE|imageUrl|https://ask.qcloudimg.com/http-save/yehe-900000/90b518868e88b98a0788123d663559bb.png|imageAlt^0|0|0|0|0|1|0|0|0^^$0|@$1|2|3|4|5|6|7|X|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|Y|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|Z|8|@]|9|@]|A|$]]|$1|I|3|J|5|K|7|10|8|@]|9|@$L|11|M|12|1|13]]|A|$]]|$1|N|3|H|5|6|7|14|8|@]|9|@]|A|$]]|$1|O|3|-4|5|6|7|15|8|@]|9|@]|A|$]]]|P|$Q|$5|R|S|T|A|$U|V|W|-4]]]]

It is a bit of a "brute force" but works ;)

<pre><code>=IF(E4/1000&lt;1;CONCATENATE(E4;" bps");IF(E4/1000&lt;1000;CONCATENATE(ROUND(E4/1000;2);" kbps");IF(E4/1000000&lt;1000;CONCATENATE(ROUND(E4/1000000;2);" mbps");IF(E4/1000000000&lt;1000;CONCATENATE(ROUND(E4/1000000000;2);" gbps")))))
</code></pre>

<a href="https://i.stack.imgur.com/csIrC.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/csIrC.png" alt="enter image description here"></a>

blocks|key|1222056|text|将此粘贴到您的值(字节)旁边，这将自动将其更改为您的值的大小。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1222057|=IF(G10>=1099511627776,CONCATENATE(ROUND((G10/1024/1024/1024/1024),1),"+TB"),IF(G10>=1073741824,CONCATENATE(ROUND((G10/1024/1024/1024),1),"+GB"),IF(G10>=1048576,CONCATENATE(ROUND((G10/1024/1024),1),"+MB"),IF(G10>=1024,CONCATENATE(ROUND((G10/1024),1),"+KB"),IF(G10>=1,CONCATENATE((G10),"+BYTES"),0)))))|offset|length|style|CODE|1222058|entityMap^0|0|0|8D|0^^$0|@$1|2|3|4|5|6|7|J|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|K|8|@$D|L|E|M|F|G]]|9|@]|A|$]]|$1|H|3|-4|5|6|7|N|8|@]|9|@]|A|$]]]|I|$]]

Paste this next to your values(bytes) and this will automatically change it to whatever your size of value is.

<code>=IF(G10&gt;=1099511627776,CONCATENATE(ROUND((G10/1024/1024/1024/1024),1)," TB"),IF(G10&gt;=1073741824,CONCATENATE(ROUND((G10/1024/1024/1024),1)," GB"),IF(G10&gt;=1048576,CONCATENATE(ROUND((G10/1024/1024),1)," MB"),IF(G10&gt;=1024,CONCATENATE(ROUND((G10/1024),1)," KB"),IF(G10&gt;=1,CONCATENATE((G10)," BYTES"),0)))))</code>

blocks|key|1437075|text|这里的所有答案都提供了10的幂的值。以下是使用适当的SI单位(+1024的倍数，即Mebibytes、Gibibytes和Tebibytes)的格式：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1437076|[>1099511627776]#.##,,,,"+TiB";[>1073741824]#.##,,,"+GiB";0.##,,"+MiB"|code-block|syntax|javascript|1437077|这支持显示两位小数的MiB、GiB和TiB。|1437078|entityMap^0|0|0|0^^$0|@$1|2|3|4|5|6|7|K|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|L|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|M|8|@]|9|@]|A|$]]|$1|I|3|-4|5|6|7|N|8|@]|9|@]|A|$]]]|J|$]]

All the answers here supply values with powers of 10. Here is a format using proper SI units (multiples of 1024, i.e. Mebibytes, Gibibytes, and Tebibytes):
<pre><code>[&gt;1099511627776]#.##,,,,&quot; TiB&quot;;[&gt;1073741824]#.##,,,&quot; GiB&quot;;0.##,,&quot; MiB&quot;
</code></pre>
This supports MiB, GiB, and TiB showing two decimal places.

blocks|key|1437126|text|如果你想在一个单元格上工作。假设是单元格F3，您可以使用以下内容：|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|1437127|=IF(F3<(1024),+F3+&+"+B",+IF(F3<(1024*1024),+QUOTIENT(F3,1024)+&+"+KB",+IF(F3<(1024*1024*1024),+QUOTIENT(F3,(1024*1024))+&+"+MB",+IF(F3<(1024*1024*1024*1024),+QUOTIENT(F3,(1024*1024*1024))+&+"+GB",+IF(F3<(1024*1024*1024*1024*1024),+QUOTIENT(F3,(1024*1024*1024*1024))+&+"+TB",+"H")))))|code-block|syntax|javascript|1437128|这已经在google+sheets上试用过了。如果否则caluse可能需要修改|1437129|entityMap^0|K|2|0|0|0^^$0|@$1|2|3|4|5|6|7|O|8|@$9|P|A|Q|B|C]]|D|@]|E|$]]|$1|F|3|G|5|H|7|R|8|@]|D|@]|E|$I|J]]|$1|K|3|L|5|6|7|S|8|@]|D|@]|E|$]]|$1|M|3|-4|5|6|7|T|8|@]|D|@]|E|$]]]|N|$]]

If you want to work on one cell. Lets say cell <code>F3</code>, you can use this:
<pre><code>=IF(F3&lt;(1024), F3 &amp; &quot; B&quot;, IF(F3&lt;(1024*1024), QUOTIENT(F3,1024) &amp; &quot; KB&quot;, IF(F3&lt;(1024*1024*1024), QUOTIENT(F3,(1024*1024)) &amp; &quot; MB&quot;, IF(F3&lt;(1024*1024*1024*1024), QUOTIENT(F3,(1024*1024*1024)) &amp; &quot; GB&quot;, IF(F3&lt;(1024*1024*1024*1024*1024), QUOTIENT(F3,(1024*1024*1024*1024)) &amp; &quot; TB&quot;, &quot;H&quot;)))))
</code></pre>
This has been tried on google sheets.
IF ELSE caluse might need modifications

blocks|key|1437192|text|我喜欢上一个分享的版本，但我想分享的是法语Excel的版本。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1437193|我用一个四舍五入函数替换了商，在小数点后有一些数字，因为这就是我需要的：|1437194|=SI(
+++F3<1024;+F3+&+"+B";+
++++++SI(F3<(1024*1024);+ARRONDI(F3/1024;2)+&+"+KB";+
++++++++++SI(F3<(1024*1024*1024);+ARRONDI(F3/(1024*1024);2)+&+"+MB";
+++++++++++++++SI(F3<(1024*1024*1024*1024);+ARRONDI(F3/(1024*1024*1024);2)+&+"+GB";
++++++++++++++++++++SI(F3<(1024*1024*1024*1024*1024);+ARRONDI(F3/(1024*1024*1024*1024);2)&+"+TB";+"H")
+++++++++++++++)+
+++++++++++)
+++++++)
+++)|code-block|syntax|javascript|1437195|entityMap^0|0|0|0^^$0|@$1|2|3|4|5|6|7|K|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|L|8|@]|9|@]|A|$]]|$1|D|3|E|5|F|7|M|8|@]|9|@]|A|$G|H]]|$1|I|3|-4|5|6|7|N|8|@]|9|@]|A|$]]]|J|$]]

I like the last version shared but I wanted share the version for French Excel.
I have replaced QUOTIENT by a ROUND function, to have some digits after the decimal point, because that is what I need:
<pre><code>=SI(
 F3&lt;1024; F3 &amp; &quot; B&quot;; 
 SI(F3&lt;(1024*1024); ARRONDI(F3/1024;2) &amp; &quot; KB&quot;; 
 SI(F3&lt;(1024*1024*1024); ARRONDI(F3/(1024*1024);2) &amp; &quot; MB&quot;;
 SI(F3&lt;(1024*1024*1024*1024); ARRONDI(F3/(1024*1024*1024);2) &amp; &quot; GB&quot;;
 SI(F3&lt;(1024*1024*1024*1024*1024); ARRONDI(F3/(1024*1024*1024*1024);2)&amp; &quot; TB&quot;; &quot;H&quot;)
 ) 
 )
 )
 )
</code></pre>

I have a value in a cell that's in bytes. But nobody can read 728398112238. I'd rather it say 678.37GB

To write a formula to format it relatively easy (here's one: <a href="http://www.yonahruss.com/2007/02/format-excel-numbers-as-gb-mb-kb-b.html">http://www.yonahruss.com/2007/02/format-excel-numbers-as-gb-mb-kb-b.html</a>)

But is there any way to do this as a 'format'? I'd like to have the big number in the cell, but have it display as the human-readable format.

How can I format bytes a cell in Excel as KB, MB, GB etc?

翻译质量差，导致语言生硬或混乱。

没有提供实际的解决方法或示例。

解答不清晰，无法理解或解决问题。

页面排版不美观，阅读体验差。

文章

问答

视频

学习中心

腾讯云实验室

直播

竞赛

腾讯云代码分析专区

腾讯iOA零信任安全管理系统专区

腾讯云架构师技术同盟交流圈

腾讯云数据库专区

腾讯云顾问专区

腾讯云原生专区

腾讯混元专区

腾讯云TCE专区

腾讯云Lighthouse专区

腾讯云HAI专区

腾讯云Edgeone专区

腾讯云存储专区

腾讯云智能专区

腾讯轻联专区 

腾讯云开发专区

TAPD专区

腾讯轻量云游戏服专区

腾讯云最具价值专家

腾讯云架构师技术同盟

腾讯云创作之星

腾讯云开发者先锋 

腾讯云代码助手

CODING DevOps

Cloud Studio

SDK中心

API中心

命令行工具

我在一个以字节为单位的单元格中有一个值。但是没人能读懂728398112238。我宁愿它是678.37‘d要编写一个公式来格式化它相对容易(这里是一个：)但是，有没有办法以“格式”的形式做到这一点呢？我希望在单元格中显示大数字，但将其显示为人类可读的格式。

问如何在Excel中将字节格式化为KB、MB、GB等？
EN

Stack Overflow用户

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问如何在Excel中将字节格式化为KB、MB、GB等？EN