Customized Cell formatting

Hi. I've read through the official help pages for cell formatting, got none. Or at least they provided not what i needed.

I'm looking for some help to format cells in this matter, to minimize the effort of filling in the correct account number format in cells.

I thought it would be like this according to their own description in help files, and predefined formatting sets But no luck in that.
Any advice on the matter?

Which format do you want to obtain?

Pecoflyer said:

Which format do you want to obtain?

Click to expand...

I would prefer to get periods between the nr seqeunces: xxxx.xx.xxxxx
All i get is spaces, not the period.
It works with spaces for the visual effect. But to separete them with periods with formatting would be better

To get

xxxx.xx.xxxxx

use the custom format

0000\.00\.00000

Or select the cells and run this code:

Sub FormatMacro()
Selection.NumberFormat = "0000\.00\.00000"
End Sub

Thank you, that did the trick