I have a SharePoint List in which one column has Account numbers like 000000123456 000012345678 C00012345
Now I have to create a calculated Column which can display the above fields as 123456 12345678 C00012345.
SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. It only takes a minute to sign up.Sign up to join this community
returns the value as text (without thousands separator)
is an error, because its not a value
So the complete formula with a basefield
=IF( ISERROR(VALUE(MyValue)) , MyValue , TEXT(VALUE(MyValue),"0") )