Credit Card Cell

dirty_cofi · May 6th, 2002, 11:08 AM

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 · May 6th, 2002, 11:11 AM

Number are limited to 15 in Excel

Asala42 · May 6th, 2002, 11:13 AM

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

Adam

zacemmel · May 6th, 2002, 11:13 AM

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

Chris Davison · May 6th, 2002, 11:33 AM

http://www.mrexcel.com/board/viewtop...c=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 · May 6th, 2002, 12:00 PM

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/

May 6th, 2002, 11:33 AM	#5
Chris Davison MrExcel MVP Join Date: Feb 2002 Location: Millbank, London, UK Posts: 1,790	http://www.mrexcel.com/board/viewtop...c=1855&forum=2 not an answer to your specific question, but this may be worth bearing in mind as your form develops... __________________ :: Pharma Z - Family drugstore ::

May 6th, 2002, 12:00 PM	#6
Jack in the UK Board Regular Join Date: Feb 2002 Posts: 3,065	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/ __________________ Free Excel based Web Toolbar available here. Jack in the UK J & R Excel Solutions "making Excel work for you"

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

May 6th, 2002, 11:08 AM	#1
dirty_cofi New Member Join Date: May 2002 Posts: 13	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

May 6th, 2002, 11:11 AM	#2
Brian from Maui Board Regular Join Date: Feb 2002 Posts: 7,743	Number are limited to 15 in Excel

May 6th, 2002, 11:13 AM	#3
Asala42 Board Regular Join Date: Feb 2002 Location: Southfield,MI USA Posts: 1,030	I think you'll want to go with a text format on this one. I believe this is an excel limitation. Adam

May 6th, 2002, 11:13 AM	#4
zacemmel Board Regular Join Date: Apr 2002 Location: Redmond, WA Posts: 636	Preface the cell with an apostrophe or format the cells as text before entering the credit card numbers.