I'm trying to create some sort of automated formatting for certain columns (except headers of course.) to take a string of numbers (and previous formatting; which should be stripped.) and format it as
1234 - 5678 - 9012
for example. Now sure I do that manually now, but once other people start using the spreadsheet it's going to look ugly unless they make a small effort to keep the format.
Is this possible?