Aug 28 2022 08:31 PM - edited Aug 28 2022 09:05 PM
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 to have it not do that.
I also tried to use a text row instead, but even that converts 001 to 1.0000000
Aug 28 2022 09:32 PM - edited Aug 28 2022 09:36 PM
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
Aug 29 2022 03:26 AM - edited Aug 29 2022 06:07 AM
@silaman 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)
Sep 14 2022 11:46 PM