Number formatting is driving me crazy...please help

ramathires · May 9th, 2002, 02:27 PM

I have an excel document that has a field for credit card number. I just merged two adjacent cells and formatted the cells to accept a number. The problems is whenever I type is 16 digits for a credit card, the 16th digit is replaced by a "0". If I type in 15 digits the number looks fine and there are no problems. But the 16th digit is always replaced by a "0". I checked the formatting and rounding properties but I cant see anything wrong. Please help. I have to get this form done today.

Brian from Maui · May 9th, 2002, 02:30 PM

Try this thread

http://www.mrexcel.com/board/viewtop...c=7409&forum=2

Barry Katcher · May 9th, 2002, 02:44 PM

I tried 16 numbers and yup, I got the same zero at the end. Dunno why.

Since I doubt that you are going to be doing any calculations (i.e. sums) based on these entries, why don't you just format the cells as "text"?

Better yet, set up a custom format. Click on Format-Cells-Custom and in the window type in #### #### #### ####.

You can then enter all 16 numbers and it will automatically display with a space between every four numbers, same as on the card. You can even get a sum this way, if you need a hash total.

Mark W. · May 9th, 2002, 02:58 PM

The largest integer that Excel will accept has 15 digits. You should format the cells containing your card numbers as Text before your enter their value. There's no need to format as numeric since you probably won't be doing arithmetic operations on card numbers.

[ This Message was edited by: Mark W. on 2002-05-09 13:59 ]

May 9th, 2002, 02:44 PM	#3
Barry Katcher Board Regular Join Date: Feb 2002 Location: Dog Beach, Florida. Yeaahh! Posts: 4,038	I tried 16 numbers and yup, I got the same zero at the end. Dunno why. Since I doubt that you are going to be doing any calculations (i.e. sums) based on these entries, why don't you just format the cells as "text"? Better yet, set up a custom format. Click on Format-Cells-Custom and in the window type in #### #### #### ####. You can then enter all 16 numbers and it will automatically display with a space between every four numbers, same as on the card. You can even get a sum this way, if you need a hash total. __________________ Barry- Photo Restoration/Enhancement http://www.smiledogproductions.com click below for detour

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

May 9th, 2002, 02:27 PM	#1
ramathires New Member Join Date: May 2002 Posts: 1	I have an excel document that has a field for credit card number. I just merged two adjacent cells and formatted the cells to accept a number. The problems is whenever I type is 16 digits for a credit card, the 16th digit is replaced by a "0". If I type in 15 digits the number looks fine and there are no problems. But the 16th digit is always replaced by a "0". I checked the formatting and rounding properties but I cant see anything wrong. Please help. I have to get this form done today.

May 9th, 2002, 02:30 PM	#2
Brian from Maui Board Regular Join Date: Feb 2002 Posts: 7,743	Try this thread http://www.mrexcel.com/board/viewtop...c=7409&forum=2

May 9th, 2002, 02:58 PM	#4
Mark W. MrExcel MVP Join Date: Feb 2002 Location: Austin, Texas USA Posts: 11,654	The largest integer that Excel will accept has 15 digits. You should format the cells containing your card numbers as Text before your enter their value. There's no need to format as numeric since you probably won't be doing arithmetic operations on card numbers. [ This Message was edited by: Mark W. on 2002-05-09 13:59 ]