如何在 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"
这篇关于如何在 Excel 中将单元格的字节格式设置为 KB、MB、GB 等?的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!