Forum Discussion

Brass Contributor

Aug 29, 2022

Sharepoint Numbering Column won't let me have 001 or 012, it won't let me start with 0

Is there a way to set a SharePoint number column to allow numbers that start with 0? We're setting up an index system and for some reason it always removes the 0 and there doesn't seem to be a way...

Brass Contributor

Aug 29, 2022

I tried to use this inside conditional formatting for the text index column, it saves fine but then when I go to see the conditional formatting its blank again, like its not applying

=AND(LEN(Column)=3;ISNUMBER(Column+0))

I find that if I set the index number inside the SharePoint library by editing the columns, it actually holds the 3 digit number fine, such as 001 or 002, but if I use the document quick parts label to enter the number while in the document, that's when it registers as 1.00000 or 2.0000 inside in SharePoint.

Not sure what is going on

RobElliott

Silver Contributor

Aug 29, 2022

Modula a number column can't start with zeros, instead create a calculated column with the following formula:

=IF(Number<10,"00"&Number,IF(AND(Number>9,Number<100),"0"&Number,Number))

Rob

Los Gallardos
Intranet, SharePoint and Power Platform Manager (and classic 1967 Morris Traveller driver)

Modula
Brass Contributor
Sep 15, 2022
Hi Rob, thankyou for your post however doing it that way caused more problems because of power automate, the text row started behaving in the end and it seems I can keep using that.