OIC...........one way to "get there" would be to type each 4-digit group
into it's own column, and then CONCATENATE them together at the end
with.......

=A1&" "&B1&" "&C1&" "&D1

Vaya con Dios,
Chuck, CABGx3

"tspraetz" wrote in message
...
I want to format this: 0000 0000 0000 0000 Charge Card Numer format. When
you
type all the numbers down the column it would put the spaces in the
number.
If you select text there is no place to enter your custom format like the
example above example.

"CLR" wrote:

Yes using "text" will
not help me in this situation.


Why not?

Vaya con Dios,
Chuck, CABGx3


"tspraetz" wrote in message
...
I wanted to Custom Format the cells for charge card numbers that are
16
digit. DS NTE was right about Excel usings 15 digits. Yes using "text"
will
not help me in this situation.

Thanks

"Dave Peterson" wrote:

You can format the cell as text (like DS NTE wrote).

Or you can prefix your entry with a single quote.

'1234123412341234

And it'll be treated as text.

tspraetz wrote:

I want to format cells to accept charge card numbers with the
spaces.

--

Dave Peterson