حل مشكلة اختفاء 0 فى الاكسل How to keep leading zeros in Excel
حل مشكلة اختفاء 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:
https://www.rise.company/forum/image.../2019/06/6.png
2. In the
Format Cells dialog, click
Number tab, and select
Text from the
Category pane. Click
OK to close the dialog. See screenshot:
https://www.rise.company/forum/image.../2019/06/7.png
Now when you type numbers with leading zeros into the range cells, the leading zeros will be retained in the cells. See screenshot:
https://www.rise.company/forum/image.../2019/06/8.png
Note: This method cannot work if you format cells as text after typing numbers.
كل ما عليك فعلة بسهولة تامة هو اعمل selection على جميع الخلايا التى تريد العمل عليها
ثم الدخول على format cell ثم اختار text هذا الامر هيخلى تلك الحقول تقرا على انها text
تقبل 0 وليست ارقام تدخل فى عمليات حسابية.