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