Jun 16 2022 01:00 PM
I have a sharepoint list with a column called "Cust Po Line#". When data is imported into the cells of this row the source data shows the data as 100000000, 200000000....1000000000, etc. I need to remove 8 zeros from the end of every number. Can this be accomplished in sharepoint. So, end result would be 100000000 would be 1 and 1000000000 would be 10.
Jun 16 2022 11:37 PM
@Kaptain_1959 How you are importing data in list rows/cells? There are multiple ways to remove zeros from the end of number like using Power automate flow or PowerShell or calculated columns, etc.
Please click Mark as Best Response & Like if my post helped you to solve your issue. This will help others to find the correct solution easily. It also closes the item. If the post was useful in other ways, please consider giving it Like.
Jun 17 2022 05:28 AM
Jun 17 2022 06:45 AM
@Kaptain_1959 If your "Cust Po Line#" is of type "Number", use below formula for calculated column:
=[Cust Po Line#]/100000000
Column settings:
Output:
Please click Mark as Best Response & Like if my post helped you to solve your issue. This will help others to find the correct solution easily. It also closes the item. If the post was useful in other ways, please consider giving it Like.