I have bank accounts in a CSV file. I need to import these into my accounting package. However, I first have to add an extra 0 as the third to last digit but also not loose the leading zero. I am unsure if I also need the dashes so have to be able to get both results. I currently have 15 digits and need 16.
So have:
134091100000125
s/be either 1340911000001025 or 13-4091-1000001-025
076421156546550
s/be either
0764211565465050 or 07-6421-1565465-050
I have tried the replace formula to get the extra zero but it dropped the leading zeros if there was one and, for those that had a leading zero, but the additional zero in the wrong place.
Solved by O. F. in 14 mins