动态格式化单元格(Dynamically format a cell)
我正在创建一个Excel Dashboard,它根据一些列表选择返回特定单元格中的Dollar Amounts。
我现在需要做的是让Cell动态格式化美元金额。
例如,如果它返回$ 3,152,234.25我希望它显示$ 3.2M,但如果它返回$ 756,253.67那么我希望它显示$ 756K等等。
有任何想法吗?
I am creating an Excel Dashboard that returns Dollar Amounts in a specific cell based on a few List Selections.
What I need to do now is have the Cell dynamically format the Dollar Amount.
For example, if it returns $3,152,234.25 I want it to display $3.2M, but if it returns $756,253.67 then I want it to display $756K and so on.
Any ideas?
最满意答案
您可以使用以下自定义格式:
[>百万] 0.0 ,, \米; 0.0,K
结果:
You could use the following custom formatting:
[>1000000]0.0,,\M;0.0,k
Result:
更多推荐
发布评论