Credit Card Cell

[dirty_cofi]

hey,

am making a order form and i have a credit card number cell but i cant get format cell to let me display the data like this:

4545-676745-5656-78787

when i format the cell with :

####-######-####-#####

it kills the last 4 digits and makes them all zeros

any ideas please

 

[Brian from Maui]

Number are limited to 15 in Excel

 

[Asala42]

I think you'll want to go with a text format on this one. I believe this is an excel limitation.

Adam

 

[zacemmel]

Preface the cell with an apostrophe or format the cells as text before entering the credit card numbers.

 

[Chris Davison]

http://www.mrexcel.com/board/viewtopic.php?topic=1855&forum=2

not an answer to your specific question, but this may be worth bearing in mind as your form develops...

 

[Jack in the UK]

all works fine for me, as many numbers as i like ::::

also you CC i copy paste and that goes in???

lost all seem ok to me.. what excel are you running,,,

and type exactly what result you want...

ill try again

just input as text try ' the numbers the ' will disapear/