Bayt.com

Start networking and exchanging professional insights

Register now or log in to join your professional community.

Follow

Excel Microsoft Excel I need to enter credit card nos (16 digits) to Excel. Will I be able to enter these nos as it is or will I have any issues?

Business Ideas Help Desk Management
user-image
Question added by Deleted user
Date Posted: 2014/11/09
Upvote (0) Views (10) Followers (1) Answers (1) Report Question
Write an Answer
Register now or log in to answer.
Asim Ali
by Asim Ali , SAP HCM Support Officer , Al Tilal Steel Company Limited

yes you can, in fact there is nothing you may can't do or have issues.

if there is not an option, you can put up a formula however you want to.

your solution lies under the format cells -> Number -> Category (Custom) -> Type.

here you can difference the FOUR-DIGITS(0000) with anything (blank,-,.,etc.)

just select the column and format cells

Write Your Answer
More Questions Like This