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 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.