如何将Excel中的单元格的字节格式设置为KB，MB，GB等？ [英] How can I format bytes a cell in Excel as KB, MB, GB etc?

问题描述

我的单元格中有一个值，以字节为单位。但是没有人可以阅读728398112238.我宁愿说678.37GB

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

写一个公式来格式化比较容易（这里是一个：http://www.yonahruss.com/2007/02/format-excel-numbers- as-gb-mb-kb-b.html ）

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

但是有什么办法可以做为格式吗？我想在单元格中拥有大数字，但可以显示为人类可读的格式。

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.

推荐答案

你在Excel的格式化功能中无法真正做出计算。您可以使用以下内容进行粗略估算：

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:

[<500000]#,##0" B ";[<500000000]#,##0,," MB";#,##0,,," GB"

更新：其他的链接似乎已经过时了（尽管我仍然可以点击它）
http://excel-answers.com/microsoft/Excel/34882622/using-comma-to-scale- large-numbers.aspx

Update: new link as other seems to have become obsolete (although I was able to click on it still) http://excel-answers.com/microsoft/Excel/34882622/using-comma-to-scale-large-numbers.aspx

这篇关于如何将Excel中的单元格的字节格式设置为KB，MB，GB等？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！