I am entering serial numbers in a Calc spreadsheet. I’d like to be able to enter the raw data while making it easy to read it in the intended format as presented on the boxes.
Here’s an example of what I enter:
A9A9A9A9A9A9A9A9A9A9A9A9
I’d like to format it as:
A9A9-A9A9-A9A9-A9A9-A9A9-A9A9
Using “@” in cell formatting only seems to allow using text of a cell for formatting, not reformat the same cell.
Short of breaking my serial #s in different cells and putting them together again in a new cell =CONCATENATE(C6,"-",D6,"-",E6,"-",F6,"-",G6)
, is there a shorter/more effective way of doing this?