ابدأ بالتواصل مع الأشخاص وتبادل معارفك المهنية

أنشئ حسابًا أو سجّل الدخول للانضمام إلى مجتمعك المهني.

متابعة

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?

user-image
تم إضافة السؤال من قبل مستخدم محذوف‎
تاريخ النشر: 2014/11/09
Asim Ali
من قبل 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

المزيد من الأسئلة المماثلة