ExcelBanter - How do I format charge card numbers?

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - How do I format charge card numbers? (https://www.excelbanter.com/excel-discussion-misc-queries/35100-how-do-i-format-charge-card-numbers.html)

tspraetz

How do I format charge card numbers?

tonywig

I'm not sure I understand the question but if you want a number to be
enetred as a set of 16 characters then display as four lots of four,
try this ...

FORMAT
CELLS
NUMBER
CUSTOM
0000 0000 0000 0000

If I've totally missed the point - sorry.

--
tonywig

------------------------------------------------------------------------
tonywig's Profile: http://www.excelforum.com/member.php...o&userid=18985
View this thread: http://www.excelforum.com/showthread...hreadid=386841

All times are GMT +1. The time now is 02:34 AM.