حل مشكلة اختفاء 0 فى الاكسل How to keep leading zeros in Excel
excel don't hide leading 0

If you want to keep the leading zeros in Excel, you just need to format the cells as Text formating befor you typing the data.
1. Select the range cells you want to type the data with leading zeros into, and right clcik to select Format Cells from the context menu. See screenshot:





2. In the Format Cells dialog, click Number tab, and select Text from the Category pane. Click OK to close the dialog. See screenshot:




Now when you type numbers with leading zeros into the range cells, the leading zeros will be retained in the cells. See screenshot:





Note: This method cannot work if you format cells as text after typing numbers.


كل ما عليك فعلة بسهولة تامة هو اعمل selection على جميع الخلايا التى تريد العمل عليها

ثم الدخول على format cell ثم اختار text هذا الامر هيخلى تلك الحقول تقرا على انها text

تقبل 0 وليست ارقام تدخل فى عمليات حسابية.