舍入

04/25/22
回答-待审

@Genevieve P。我希望你很抱歉再次,请我能在以下问题上得到一些帮助。


例如,我想在单元格中输入5979.100258,它的四舍五入为5979.10026—这是我不想要的。我怎样才能让我的数字保持精确呢?


不好意思直接把这个给。

标签:

答案

  • @Majid卡亚尼

    Smartsheet对小数的最大支持是小数点后5位。

    保罗在这篇文章中提出了另一种解决方案:

    Good morning, <\/p>

    I have specific coding for each line item that reads as 7 digits with a "." followed by another 7 digits. So in essence, it looks like a long decimal. Smartsheets thinks it's a decimal and rounds it up, eliminating the last 2 digits when I leave the cell. Losing the last 2 digits changes the number and messes up my coding. Also, people with read only access to my sheet can't see the full coding string that is needed.<\/p>

    When I try to extend the decimal places, it stops me at 5. So I tried to create a formula separating the one column into two separate columns, using the "Left" and "Right" formulas, but the "Right" formula only pulls the 5 decimal places, not the full 7. <\/p>

    Is there any fix for the added decimals or a way to make the full string visible? <\/p>

    Thanks you.<\/p>","bodyRaw":"[{\"insert\":\"Good morning, \\nI have specific coding for each line item that reads as 7 digits with a \\\".\\\" followed by another 7 digits. So in essence, it looks like a long decimal. Smartsheets thinks it's a decimal and rounds it up, eliminating the last 2 digits when I leave the cell. Losing the last 2 digits changes the number and messes up my coding. Also, people with read only access to my sheet can't see the full coding string that is needed.\\nWhen I try to extend the decimal places, it stops me at 5. So I tried to create a formula separating the one column into two separate columns, using the \\\"Left\\\" and \\\"Right\\\" formulas, but the \\\"Right\\\" formula only pulls the 5 decimal places, not the full 7. \\nIs there any fix for the added decimals or a way to make the full string visible? \\nThanks you.\\n\"}]","format":"rich","dateInserted":"2020-07-28T14:03:36+00:00","insertUser":{"userID":121795,"name":"Dominick Vargas","url":"https:\/\/community.smartsheet.com\/profile\/Dominick%20Vargas","photoUrl":"https:\/\/lh5.googleusercontent.com\/-K3DRXBl7OB0\/AAAAAAAAAAI\/AAAAAAAAAAA\/AB6qoq0e06wcsLG3HjNYaJDiLPrWcIBmsg\/mo\/photo.jpg","dateLastActive":"2020-07-28T17:09:26+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"displayOptions":{"showUserLabel":false,"showCompactUserInfo":true,"showDiscussionLink":true,"showPostLink":true,"showCategoryLink":false,"renderFullContent":false,"expandByDefault":false},"url":"https:\/\/community.smartsheet.com\/discussion\/70181\/long-decimals-7-digit-decimals","embedType":"quote","name":"Long Decimals - 7 digit decimals"}"> https://community.smartsheet.com/discussion/70181/long-decimals-7-digit-decimals

    但是请记住,这会将值存储为文本值,因此不能进行数学计算(例如SUM)。

    欢呼,

    吉纳维芙

登录注册置评。