Forum Discussion
Giant stupid numbers
My county assessor provided a CSV download of tax info; and one data field is a parcel number. Here is one 17-digit example: 366629301057000009 what I want to do is format it like this: 36-...
Another way is
=REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(B2,16,0,"-"),13,0,"."),10,0,"-"),7,0,"-"),5,0,"-"),3,0,"-")
Please see attached