Formatted Cell in Excel

问题:

I would like to ask how to format the cell in MS Excel.

I have a text "AB12122" and I would like to format into "AB12-122" without using any formula.

Is this possible?

Thank you in advance.

回答1:

I just dug around Google, and it looks like the only way to do it is with a formula. The custom formatting is really only useful for numbers. I can however make it say AB12122AB12122AB12122AB12122-AB12122AB12122, if that's helpful. :)

Why can't you use a formula?

回答2:

You may use character masking under Format Cells > Custom.