另一个excel公式情况 [英] Another excel formula situation

问题描述

我希望能够将秒数差异显示为 (+4.15) 或有时显示为负数 (-4.15) 并包括括号和加号/减号.

I want to be able to display a difference in seconds as (+4.15) or sometimes negatively as (-4.15) and include the parentheses and plus/minus sign.

如何使用公式来显示 34.47-30.32，以便知道差异是正数还是负数 4.15?

How can I use a formula to display 34.47-30.32 so it comes out knowing whether or not the difference is positive or negative 4.15?

这已经解决了，只是我的下一个问题很小，但是任何以 0 结尾的数字，例如 4.10，将显示为 4.1，没有额外的 0.使用第一条评论中给出的公式，我无法格式化它准确显示 4.10.是否可以?甚至单元格格式都不能显示两位小数

This is solved now except my next issue is small, but any number ending in 0, such as 4.10, will display as 4.1, without the extra 0. Using the formula given in the first comment, I can't format this to show exactly 4.10. Is it possible? not even cell formatting to show two decimal places works

推荐答案

您可以使用 Excel 中的常规单元格格式选项来实现这一点.

You can achieve this with the regular cell formats option in excel.

格式化您的单元格以这种方式显示数字.或者，如果您需要除现有选项之外的其他选项，请使用自定义格式.

Format your cells to show the number in this way. Or if you need something other than the already available options, then use custom formats.

这篇关于另一个excel公式情况的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！