I have a column with 10 digit numbers. I need to insert two decimal places into the number after the fourth and sixth digit. For example:
8523495000 -> 8523.49.5000
8443321020 -> 8443.32.1020
8523493000 -> 8523.49.3000
Does anyone have a formula that can help add these decimal places?
Bookmarks