Home دروس الاكسيل

كفية تنسيق التاريخ في برنامج مايكروسوفت Excel

September 14, 2021

كفية تنسيق التاريخ في برنامج مايكروسوفت Excel

يوفر لنا برنامج مايكروسوفت Excel عدة تنسيقات التاريخ لاستخدامها , لأننا في كثير من الأحيان نحتاج لتغيير التنسيق من شكل الى اخر لكي يناسب عرض بيانتنا. لذا من خلال هذه التدوينة سنتعرف على كفية تنسيق التاريخ في برنامج مايكروسوفت Excel.

مثال :

المثال التالى يحتوى على بيانات بعض الأشخاص , ونريد تغيير تنسيق تاريخ الميلاد . :

- الاسم

- الوظيفة

- تاريخ الميلاد

نقوم أولا بتحديد النطاق الذى يحتوى على تاريخ الميلاد وهو النطاق C2:C6 ثم نضغط بزر الماوس الأيمن , ثم من القائمة المختصرة نقوم بالضغط على الإختيار Format Cells

سيظهر مربع الحوار :

من الجانب الأيسر نقوم بإختيار Date اذا لم يكن محددا .
من الجانب الأيمن نقوم بإختيار شكل التنسيق الذى نريده .
نضغط على زر OK

سيتم تغيير تنسيق تاريخ الميلاد إلى التنسيق الذى قمنا بإختياره .

Tags دروس الاكسيل

Latest articles from : دروس الاكسيل

Comments

No comments

Post a Comment

Reading Mode :

Font Size

+

16

-

lines height

+

2

-

window['__wavt'] = 'AOuZoY6pWHbTC9Ig0bYjylZ6a-sVEK_7Tg:1733717749565';_WidgetManager._Init('//www.blogger.com/rearrange?blogID\x3d7172743834752994373','//www.practiceexcel-365.com/2021/09/excel_01780285209.html','7172743834752994373'); _WidgetManager._SetDataContext([{'name': 'blog', 'data': {'blogId': '7172743834752994373', 'title': 'Practice Excel365 | Free Excel Courses', 'url': 'https://www.practiceexcel-365.com/2021/09/excel_01780285209.html', 'canonicalUrl': 'https://www.practiceexcel-365.com/2021/09/excel_01780285209.html', 'homepageUrl': 'https://www.practiceexcel-365.com/', 'searchUrl': 'https://www.practiceexcel-365.com/search', 'canonicalHomepageUrl': 'https://www.practiceexcel-365.com/', 'blogspotFaviconUrl': 'https://www.practiceexcel-365.com/favicon.ico', 'bloggerUrl': 'https://www.blogger.com', 'hasCustomDomain': true, 'httpsEnabled': true, 'enabledCommentProfileImages': true, 'gPlusViewType': 'FILTERED_POSTMOD', 'adultContent': false, 'analyticsAccountNumber': '', 'encoding': 'UTF-8', 'locale': 'en', 'localeUnderscoreDelimited': 'en', 'languageDirection': 'ltr', 'isPrivate': false, 'isMobile': false, 'isMobileRequest': false, 'mobileClass': '', 'isPrivateBlog': false, 'isDynamicViewsAvailable': true, 'feedLinks': '\x3clink rel\x3d\x22alternate\x22 type\x3d\x22application/atom+xml\x22 title\x3d\x22Practice Excel365 | Free Excel Courses - Atom\x22 href\x3d\x22https://www.practiceexcel-365.com/feeds/posts/default\x22 /\x3e\n\x3clink rel\x3d\x22alternate\x22 type\x3d\x22application/rss+xml\x22 title\x3d\x22Practice Excel365 | Free Excel Courses - RSS\x22 href\x3d\x22https://www.practiceexcel-365.com/feeds/posts/default?alt\x3drss\x22 /\x3e\n\x3clink rel\x3d\x22service.post\x22 type\x3d\x22application/atom+xml\x22 title\x3d\x22Practice Excel365 | Free Excel Courses - Atom\x22 href\x3d\x22https://www.blogger.com/feeds/7172743834752994373/posts/default\x22 /\x3e\n\n\x3clink rel\x3d\x22alternate\x22 type\x3d\x22application/atom+xml\x22 title\x3d\x22Practice Excel365 | Free Excel Courses - Atom\x22 href\x3d\x22https://www.practiceexcel-365.com/feeds/8162478883693721468/comments/default\x22 /\x3e\n', 'meTag': '', 'adsenseClientId': 'ca-pub-6657372632750930', 'adsenseHostId': 'ca-host-pub-1556223355139109', 'adsenseHasAds': true, 'adsenseAutoAds': true, 'boqCommentIframeForm': true, 'loginRedirectParam': '', 'view': '', 'dynamicViewsCommentsSrc': '//www.blogblog.com/dynamicviews/4224c15c4e7c9321/js/comments.js', 'dynamicViewsScriptSrc': '//www.blogblog.com/dynamicviews/36eb93a0ea1bb211', 'plusOneApiSrc': 'https://apis.google.com/js/platform.js', 'disableGComments': true, 'interstitialAccepted': false, 'sharing': {'platforms': [{'name': 'Get link', 'key': 'link', 'shareMessage': 'Get link', 'target': ''}, {'name': 'Facebook', 'key': 'facebook', 'shareMessage': 'Share to Facebook', 'target': 'facebook'}, {'name': 'BlogThis!', 'key': 'blogThis', 'shareMessage': 'BlogThis!', 'target': 'blog'}, {'name': 'X', 'key': 'twitter', 'shareMessage': 'Share to X', 'target': 'twitter'}, {'name': 'Pinterest', 'key': 'pinterest', 'shareMessage': 'Share to Pinterest', 'target': 'pinterest'}, {'name': 'Email', 'key': 'email', 'shareMessage': 'Email', 'target': 'email'}], 'disableGooglePlus': true, 'googlePlusShareButtonWidth': 0, 'googlePlusBootstrap': '\x3cscript type\x3d\x22text/javascript\x22\x3ewindow.___gcfg \x3d {\x27lang\x27: \x27en\x27};\x3c/script\x3e'}, 'hasCustomJumpLinkMessage': true, 'jumpLinkMessage': 'Read more \xbb', 'pageType': 'item', 'postId': '8162478883693721468', 'postImageThumbnailUrl': 'https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhNMEPvhc-_h8zRF12Uwm08hP48vbVr8iBpjUpyHbI5WLVJowtjzFRhE-0saxYEw8nPuDJKUlQRoVSc13I2hehYIjEV2hB19ht6GiXpw2zYf0c3A_laHZ4Nr8PmyKygQTuunj2P1iavCaQ/s72-c/30.png', 'postImageUrl': 'https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhNMEPvhc-_h8zRF12Uwm08hP48vbVr8iBpjUpyHbI5WLVJowtjzFRhE-0saxYEw8nPuDJKUlQRoVSc13I2hehYIjEV2hB19ht6GiXpw2zYf0c3A_laHZ4Nr8PmyKygQTuunj2P1iavCaQ/s320/30.png', 'pageName': '\u0643\u0641\u064a\u0629 \u062a\u0646\u0633\u064a\u0642 \u0627\u0644\u062a\u0627\u0631\u064a\u062e \u0641\u064a \u0628\u0631\u0646\u0627\u0645\u062c \u0645\u0627\u064a\u0643\u0631\u0648\u0633\u0648\u0641\u062a Excel', 'pageTitle': 'Practice Excel365 | Free Excel Courses: \u0643\u0641\u064a\u0629 \u062a\u0646\u0633\u064a\u0642 \u0627\u0644\u062a\u0627\u0631\u064a\u062e \u0641\u064a \u0628\u0631\u0646\u0627\u0645\u062c \u0645\u0627\u064a\u0643\u0631\u0648\u0633\u0648\u0641\u062a Excel', 'metaDescription': '\u064a\u0648\u0641\u0631 \u0644\u0646\u0627 \u0628\u0631\u0646\u0627\u0645\u062c \u0645\u0627\u064a\u0643\u0631\u0648\u0633\u0648\u0641\u062a Excel \u0639\u062f\u0629 \u062a\u0646\u0633\u064a\u0642\u0627\u062a \u0627\u0644\u062a\u0627\u0631\u064a\u062e \u0644\u0627\u0633\u062a\u062e\u062f\u0627\u0645\u0647\u0627 , \u0644\u0623\u0646\u0646\u0627 \u0641\u064a \u0643\u062b\u064a\u0631 \u0645\u0646 \u0627\u0644\u0623\u062d\u064a\u0627\u0646 \u0646\u062d\u062a\u0627\u062c \u0644\u062a\u063a\u064a\u064a\u0631 \u0627\u0644\u062a\u0646\u0633\u064a\u0642 \u0645\u0646 \u0634\u0643\u0644 \u0627\u0644\u0649 \u0627\u062e\u0631 \u0644\u0643\u064a \u064a\u0646\u0627\u0633\u0628 \u0639\u0631\u0636 \u0628\u064a\u0627\u0646\u062a\u0646\u0627. '}}, {'name': 'features', 'data': {}}, {'name': 'messages', 'data': {'edit': 'Edit', 'linkCopiedToClipboard': 'Link copied to clipboard!', 'ok': 'Ok', 'postLink': 'Post Link'}}, {'name': 'template', 'data': {'name': 'custom', 'localizedName': 'Custom', 'isResponsive': true, 'isAlternateRendering': false, 'isCustom': true}}, {'name': 'view', 'data': {'classic': {'name': 'classic', 'url': '?view\x3dclassic'}, 'flipcard': {'name': 'flipcard', 'url': '?view\x3dflipcard'}, 'magazine': {'name': 'magazine', 'url': '?view\x3dmagazine'}, 'mosaic': {'name': 'mosaic', 'url': '?view\x3dmosaic'}, 'sidebar': {'name': 'sidebar', 'url': '?view\x3dsidebar'}, 'snapshot': {'name': 'snapshot', 'url': '?view\x3dsnapshot'}, 'timeslide': {'name': 'timeslide', 'url': '?view\x3dtimeslide'}, 'isMobile': false, 'title': '\u0643\u0641\u064a\u0629 \u062a\u0646\u0633\u064a\u0642 \u0627\u0644\u062a\u0627\u0631\u064a\u062e \u0641\u064a \u0628\u0631\u0646\u0627\u0645\u062c \u0645\u0627\u064a\u0643\u0631\u0648\u0633\u0648\u0641\u062a Excel', 'description': '\u064a\u0648\u0641\u0631 \u0644\u0646\u0627 \u0628\u0631\u0646\u0627\u0645\u062c \u0645\u0627\u064a\u0643\u0631\u0648\u0633\u0648\u0641\u062a Excel \u0639\u062f\u0629 \u062a\u0646\u0633\u064a\u0642\u0627\u062a \u0627\u0644\u062a\u0627\u0631\u064a\u062e \u0644\u0627\u0633\u062a\u062e\u062f\u0627\u0645\u0647\u0627 , \u0644\u0623\u0646\u0646\u0627 \u0641\u064a \u0643\u062b\u064a\u0631 \u0645\u0646 \u0627\u0644\u0623\u062d\u064a\u0627\u0646 \u0646\u062d\u062a\u0627\u062c \u0644\u062a\u063a\u064a\u064a\u0631 \u0627\u0644\u062a\u0646\u0633\u064a\u0642 \u0645\u0646 \u0634\u0643\u0644 \u0627\u0644\u0649 \u0627\u062e\u0631 \u0644\u0643\u064a \u064a\u0646\u0627\u0633\u0628 \u0639\u0631\u0636 \u0628\u064a\u0627\u0646\u062a\u0646\u0627. ', 'featuredImage': 'https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhNMEPvhc-_h8zRF12Uwm08hP48vbVr8iBpjUpyHbI5WLVJowtjzFRhE-0saxYEw8nPuDJKUlQRoVSc13I2hehYIjEV2hB19ht6GiXpw2zYf0c3A_laHZ4Nr8PmyKygQTuunj2P1iavCaQ/s320/30.png', 'url': 'https://www.practiceexcel-365.com/2021/09/excel_01780285209.html', 'type': 'item', 'isSingleItem': true, 'isMultipleItems': false, 'isError': false, 'isPage': false, 'isPost': true, 'isHomepage': false, 'isArchive': false, 'isLabelSearch': false, 'postId': 8162478883693721468}}, {'name': 'widgets', 'data': [{'title': 'BlogArchive', 'type': 'BlogArchive', 'sectionId': 'sitting', 'id': 'BlogArchive400'}, {'title': 'BlogLabels', 'type': 'Label', 'sectionId': 'sitting', 'id': 'Label400'}, {'title': 'Pages', 'type': 'PageList', 'sectionId': 'pages', 'id': 'PageList1'}, {'title': '\u0645\u0648\u0627\u0642\u0639 \u0627\u0644\u062a\u0648\u0627\u0635\u0644 \u0627\u0644\u0625\u062c\u062a\u0645\u0627\u0639\u064a', 'type': 'LinkList', 'sectionId': 'topsocialL', 'id': 'LinkList3'}, {'title': 'Practice Excel365 | Free Excel Courses (Header)', 'type': 'Header', 'sectionId': 'logo', 'id': 'Header1'}, {'title': '\u0627\u0644\u0642\u0627\u0626\u0645\u0629 \u0627\u0644\u0631\u0626\u064a\u0633\u064a\u0629', 'type': 'LinkList', 'sectionId': 'menu', 'id': 'LinkList22'}, {'title': '\u0627\u0639\u0644\u0627\u0646 \u0627\u0633\u0641\u0644 \u0627\u0644\u0642\u0627\u0626\u0645\u0629 \u0627\u0644\u0639\u0644\u0648\u064a\u0629 \u0644\u0644\u062d\u0627\u0633\u0648\u0628', 'type': 'HTML', 'sectionId': 'Topa3lan-sc', 'id': 'HTML100'}, {'title': '\u0627\u0639\u0644\u0627\u0646 \u0627\u0633\u0641\u0644 \u0627\u0644\u0642\u0627\u0626\u0645\u0629 \u0627\u0644\u0639\u0644\u0648\u064a\u0629 \u0644\u0644\u0647\u0627\u062a\u0641', 'type': 'HTML', 'sectionId': 'Topa3lan-sc2', 'id': 'HTML101'}, {'title': 'Blog Posts', 'type': 'Blog', 'sectionId': 'Tempnec', 'id': 'Blog1', 'posts': [{'id': '8162478883693721468', 'title': '\u0643\u0641\u064a\u0629 \u062a\u0646\u0633\u064a\u0642 \u0627\u0644\u062a\u0627\u0631\u064a\u062e \u0641\u064a \u0628\u0631\u0646\u0627\u0645\u062c \u0645\u0627\u064a\u0643\u0631\u0648\u0633\u0648\u0641\u062a Excel', 'featuredImage': 'https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhNMEPvhc-_h8zRF12Uwm08hP48vbVr8iBpjUpyHbI5WLVJowtjzFRhE-0saxYEw8nPuDJKUlQRoVSc13I2hehYIjEV2hB19ht6GiXpw2zYf0c3A_laHZ4Nr8PmyKygQTuunj2P1iavCaQ/s320/30.png', 'showInlineAds': false}], 'headerByline': {'regionName': 'header1', 'items': [{'name': 'share', 'label': ''}, {'name': 'timestamp', 'label': '-'}]}, 'footerBylines': [{'regionName': 'footer1', 'items': [{'name': 'comments', 'label': 'comments'}, {'name': 'icons', 'label': ''}]}, {'regionName': 'footer2', 'items': [{'name': 'labels', 'label': ''}]}], 'allBylineItems': [{'name': 'share', 'label': ''}, {'name': 'timestamp', 'label': '-'}, {'name': 'comments', 'label': 'comments'}, {'name': 'icons', 'label': ''}, {'name': 'labels', 'label': ''}]}, {'title': '\u0623\u0639\u0644\u0627\u0646 \u0627\u0648\u0644 \u0627\u0644\u0645\u0648\u0636\u0648\u0639', 'type': 'HTML', 'sectionId': 'PostA3lan', 'id': 'HTML201'}, {'title': '\u0627\u0639\u0644\u0627\u0646 \u0628\u0639\u062f \u0643\u0644 \u0639\u0646\u0648\u0627\u0646 [\u0645\u062a\u0643\u0631\u0631]', 'type': 'HTML', 'sectionId': 'PostA3lan2', 'id': 'HTML222'}, {'title': '\u0627\u0639\u0644\u0627\u0646 \u0628\u0639\u062f \u0643\u0644 \u0641\u0642\u0631\u0629 [\u0645\u062a\u0643\u0631\u0631]', 'type': 'HTML', 'sectionId': 'PostA3lan2', 'id': 'HTML223'}, {'title': 'Contact Form', 'type': 'ContactForm', 'sectionId': 'AddOns', 'id': 'ContactForm200'}, {'title': '\u0645\u0648\u0627\u0642\u0639 \u0627\u0644\u062a\u0648\u0627\u0635\u0644 \u0627\u0644\u0625\u062c\u062a\u0645\u0627\u0639\u064a', 'type': 'LinkList', 'sectionId': 'sidepar', 'id': 'LinkList4'}, {'title': 'Fiver', 'type': 'HTML', 'sectionId': 'Postnw6', 'id': 'HTML3'}, {'title': '\u0645\u0648\u0627\u0642\u0639 \u0627\u0644\u062a\u0648\u0627\u0635\u0644 \u0627\u0644\u0625\u062c\u062a\u0645\u0627\u0639\u064a', 'type': 'LinkList', 'sectionId': 'footer-social', 'id': 'LinkList2'}]}]); _WidgetManager._RegisterWidget('_BlogArchiveView', new _WidgetInfo('BlogArchive400', 'sitting', document.getElementById('BlogArchive400'), {'languageDirection': 'ltr', 'loadingMessage': 'Loading\x26hellip;'}, 'displayModeFull')); _WidgetManager._RegisterWidget('_LabelView', new _WidgetInfo('Label400', 'sitting', document.getElementById('Label400'), {}, 'displayModeFull')); _WidgetManager._RegisterWidget('_PageListView', new _WidgetInfo('PageList1', 'pages', document.getElementById('PageList1'), {'title': 'Pages', 'links': [{'isCurrentPage': false, 'href': 'http://www.practiceexcel-365.com/', 'title': 'Home'}, {'isCurrentPage': false, 'href': 'https://www.practiceexcel-365.com/p/privacy-policy.html', 'id': '9039293699451073275', 'title': 'Privacy Policy'}, {'isCurrentPage': false, 'href': 'https://www.practiceexcel-365.com/p/who-are-we.html', 'id': '3848084781500635721', 'title': 'Who We Are'}, {'isCurrentPage': false, 'href': 'https://www.practiceexcel-365.com/p/contact-us.html', 'id': '5696516493396065643', 'title': 'Contact Us'}, {'isCurrentPage': false, 'href': 'https://www.practiceexcel-365.com/p/blog-page.html', 'id': '4724947008150640905', 'title': 'Frequently Asked Questions'}], 'mobile': false, 'showPlaceholder': true, 'hasCurrentPage': false}, 'displayModeFull')); _WidgetManager._RegisterWidget('_LinkListView', new _WidgetInfo('LinkList3', 'topsocialL', document.getElementById('LinkList3'), {}, 'displayModeFull')); _WidgetManager._RegisterWidget('_HeaderView', new _WidgetInfo('Header1', 'logo', document.getElementById('Header1'), {}, 'displayModeFull')); _WidgetManager._RegisterWidget('_LinkListView', new _WidgetInfo('LinkList22', 'menu', document.getElementById('LinkList22'), {}, 'displayModeFull')); _WidgetManager._RegisterWidget('_HTMLView', new _WidgetInfo('HTML100', 'Topa3lan-sc', document.getElementById('HTML100'), {}, 'displayModeFull')); _WidgetManager._RegisterWidget('_HTMLView', new _WidgetInfo('HTML101', 'Topa3lan-sc2', document.getElementById('HTML101'), {}, 'displayModeFull')); _WidgetManager._RegisterWidget('_BlogView', new _WidgetInfo('Blog1', 'Tempnec', document.getElementById('Blog1'), {'cmtInteractionsEnabled': false, 'lightboxEnabled': true, 'lightboxModuleUrl': 'https://www.blogger.com/static/v1/jsbin/2385764300-lbx.js', 'lightboxCssUrl': 'https://www.blogger.com/static/v1/v-css/1964470060-lightbox_bundle.css'}, 'displayModeFull')); _WidgetManager._RegisterWidget('_HTMLView', new _WidgetInfo('HTML201', 'PostA3lan', document.getElementById('HTML201'), {}, 'displayModeFull')); _WidgetManager._RegisterWidget('_HTMLView', new _WidgetInfo('HTML222', 'PostA3lan2', document.getElementById('HTML222'), {}, 'displayModeFull')); _WidgetManager._RegisterWidget('_HTMLView', new _WidgetInfo('HTML223', 'PostA3lan2', document.getElementById('HTML223'), {}, 'displayModeFull')); _WidgetManager._RegisterWidget('_ContactFormView', new _WidgetInfo('ContactForm200', 'AddOns', document.getElementById('ContactForm200'), {'contactFormMessageSendingMsg': 'Sending...', 'contactFormMessageSentMsg': 'Your message has been sent.', 'contactFormMessageNotSentMsg': 'Message could not be sent. Please try again later.', 'contactFormInvalidEmailMsg': 'A valid email address is required.', 'contactFormEmptyMessageMsg': 'Message field cannot be empty.', 'title': 'Contact Form', 'blogId': '7172743834752994373', 'contactFormNameMsg': 'Name', 'contactFormEmailMsg': 'Email', 'contactFormMessageMsg': 'Message', 'contactFormSendMsg': 'Send', 'contactFormToken': 'AOuZoY7t8HJahStoW23vUMPInwEjkOhlcQ:1733717749565', 'submitUrl': 'https://www.blogger.com/contact-form.do'}, 'displayModeFull')); _WidgetManager._RegisterWidget('_LinkListView', new _WidgetInfo('LinkList4', 'sidepar', document.getElementById('LinkList4'), {}, 'displayModeFull')); _WidgetManager._RegisterWidget('_HTMLView', new _WidgetInfo('HTML3', 'Postnw6', document.getElementById('HTML3'), {}, 'displayModeFull')); _WidgetManager._RegisterWidget('_LinkListView', new _WidgetInfo('LinkList2', 'footer-social', document.getElementById('LinkList2'), {}, 'displayModeFull'));