Forum Discussion
Removing digits from a number in a Sharepoint List
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...
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.
- The data is imported from a CSV file that is downloaded from our Sage accounting software. The currents sharepoint list has hundreds of entries so my first thought is to use a calculated column in the sharepoint list. I know how to accomplish this in excel.
