Hi

with the selected cell, right click, select Format Cells, select custom, and
enter "0"'s where you want digits, and spaces where you want spaces, eg"0000
0000 0000 000". While when entering it will not have spaces, it will enter
correctly.


"tspraetz" wrote:

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