Forum Discussion
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...
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)
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.