trying to remove a comma from a calculated field RRS feed

  • Question

  • In a SharePoint calcualted column, I am trying to remove a comma from the results.  My formula is simple, I'm simply trying to take the item ID number and add 5000 to it.  For example, if the list ID number is 15, I want the result of the caculated field to be "5015" and NOT "5,015".  Can you help?

    Wednesday, January 25, 2012 7:30 PM


  • Hi Brian,


    You can use the function TEXT(value,format_text) in the calculated column.


    In your scenario, the formula should like: TEXT(ID+”5000”,”0”)



    Pengyu Zhao

    TechNet Community Support

    • Proposed as answer by Rashu,Rahul Tuesday, January 31, 2012 2:35 AM
    • Marked as answer by Pengyu Zhao Thursday, February 2, 2012 7:19 AM
    Monday, January 30, 2012 7:34 AM