dirty_cofi
New Member
- Joined
- May 5, 2002
- Messages
- 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
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