如何在数字字段中保持前导零 [英] How to keep leading zeros in number field

问题描述

我有一个类型为"Number"的字段，并且我要保存值"012345678".

不幸的是，当打开表单时，我看到的是"12345678".没有前导零.

是否可以具有与数字"字段中输入的值完全相同的值?

谢谢.

解决方案

嗨

看看类似的线程

https://social.technet.microsoft.com/Forums/office/zh-CN/8d7560ab-cd2a-4e65-ae13-49327f07210d/display-numbers-without-commas?forum=sharepointgenerallegacy

Hi,

I have field of type "Number" and I am saving the value "012345678".

Unfortunatelly when a form is opened what I see is "12345678" without leading zero.

Is it possible to have exactly the same value which was entered inside of Number field?

Thanks.

解决方案

Hi CaMeL023,

if you want to preserve the value with this pattern, you need to convert the field type of number to string .For ID number with fixed-length, I suggest you to use Single line of text column instead of number column.

OR

create an additional field that calculates a value based on the Number field and ignores all non-numeric parts. This is relatively straightforward, and can be accomplished entirely within the browser:

=TEXT([MyNumericData], "0")

have a look on similar thread 

https://social.technet.microsoft.com/Forums/office/en-US/8d7560ab-cd2a-4e65-ae13-49327f07210d/display-numbers-without-commas?forum=sharepointgenerallegacy

这篇关于如何在数字字段中保持前导零的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！