Break CCard Number into sets of four

[stokie21]

Hi guys, How do i get a cell to break a card number into sets of 4?

at the moment its in one big lump!

1234567891234567

i want the satff to enter the card number as above, but i also want excel to spit it for me so it reads 1234 5678 9123 4567


Thanks

 

[Norie]

Hermanito

I didn't think it would work but like you I tested.

I'm sure I had problems with merged cells and the change event recently.

Though when I think about it, it might actually have been selection change.

 

[stokie21]

It does work with merged cells, but I still wouldn't recommend using them.

Try formatting the cells as Center Across Selection.

As for the code not working, where did you put it?

It should go in the worksheet module of whatever worksheet the credit card details are being entered in.

I right clicked the sheet number at the bottom of the page and went to view code

it opened an edit thingy and a little white window i then put the code in there, i clicked save and got this

 

[Norie]

You need to save the file as macro-enabled, ie xlsm.

 

[stokie21]

thats better!! works now!

Thanks for all your help with this one

Just hope it works in office 2007 as i have doen it all in 2010!

Thanks

 

[Norie]

It should, but if you can you should do this sort of thing in the earliest version of Excel the workbook could be used with.