Credit card formatting

[g.tavy]

Hello everyone,
(This should be simple)
I'm trying to format the number input in a cell to appear as 0000 0000 0000 0000. (groups of four with spaces inbetween).
I am using custom formating and it seems to be working BUT the last digit is not right. For eg; i type 1234 5678 9123 4567 but it is coming up with 1234 5678 9123 4560. the last digit is changeing.
Why is this so?? can anyone help with this delema.

 

[VoG]

Excel will only display 15 significant figures.

Try formatting as Text then entering

1234 1234 1234 1234

 

[g.tavy]

thanks for your help and understanding.
I didnt know only 15 number are displayed.

But the input has to be in the same cell as it is typed...
how do you do that...

 

[VoG]

You have to either format the cell as Text (CTRL + 1, click Text, click OK) or precede with an apostrophe ('). Unfortunately you will need to key in the spaces

Excel Workbook
	A
1	1234 1234 1234 1234
2	1234 1234 1234 1234
Sheet1

 

[VoG]

Another option: enter in blocks of four digits then concatenate

Excel Workbook
	A	B	C	D	E
1	1234	5678	9012	3456	1234 5678 9012 3456
Sheet2

 

[g.tavy]

thank you all..
great help...