Forum Discussion
Solved
How to format a list column to have the numbers in the format "0000"
Everything is in the question. I would like to format a number title column of one of my list to have four digits. For example "45" will be "0045". Could you help me?
EiC4733 you can format the column with the following JSON to achieve this:
{ "$schema": "https://developer.microsoft.com/json-schemas/sp/column-formatting.schema.json", "elmType": "div", "txtContent": "=if(@currentField <= 9, '000'+'@currentField', (if(@currentField >= 10 && @currentField <= 99,'00'+'@currentField', (if(@currentField >= 1000 ,'@currentField','0'+'@currentField'))" }Rob
Los Gallardos
Intranet, SharePoint and Power Platform Manager (and classic 1967 Morris Traveller driver)
EiC4733 you can format the column with the following JSON to achieve this:
{
"$schema": "https://developer.microsoft.com/json-schemas/sp/column-formatting.schema.json",
"elmType": "div",
"txtContent": "=if(@currentField <= 9, '000'+'@currentField', (if(@currentField >= 10 && @currentField <= 99,'00'+'@currentField', (if(@currentField >= 1000 ,'@currentField','0'+'@currentField'))"
}
Rob
Los Gallardos
Intranet, SharePoint and Power Platform Manager (and classic 1967 Morris Traveller driver)
Great