ramathires
New Member
- Joined
- May 8, 2002
- Messages
- 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.