{"id":2332,"date":"2021-10-28T01:14:30","date_gmt":"2021-10-28T01:14:30","guid":{"rendered":"https:\/\/lgildv5i97.onrocket.site\/answers\/?post_type=question&#038;p=2332"},"modified":"2021-10-28T01:14:54","modified_gmt":"2021-10-28T01:14:54","slug":"excel-chge-input-date-format-mm-dd-dd-mm","status":"publish","type":"question","link":"https:\/\/computing.net\/answers\/office\/excel-chge-input-date-format-mmdd-ddmm\/12556.html","title":{"rendered":"Excel: Chge &#8216;Input&#8217; Date Format MM\/dd dd\/MM"},"content":{"rendered":"<p>Hello,<\/p>\n<p>I know how to change &#8216;output&#8217; format of dates on Excel<br \/>\nHowever,<br \/>\nDoes any one know how to change the &#8216;input&#8217; format of a date ?<\/p>\n<p>&#8211;&gt; i.e. when I enter 5\/10\/09, the computer understands 10-May-09 instead of 5-Oct-09<\/p>\n<p>thx<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"inline_featured_image":false,"iawp_total_views":2},"question-category":[53],"question_tags":[],"class_list":["post-2332","question","type-question","status-publish","hentry","question-category-office"],"jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/computing.net\/answers\/wp-json\/wp\/v2\/question\/2332","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/computing.net\/answers\/wp-json\/wp\/v2\/question"}],"about":[{"href":"https:\/\/computing.net\/answers\/wp-json\/wp\/v2\/types\/question"}],"author":[{"embeddable":true,"href":"https:\/\/computing.net\/answers\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/computing.net\/answers\/wp-json\/wp\/v2\/comments?post=2332"}],"wp:attachment":[{"href":"https:\/\/computing.net\/answers\/wp-json\/wp\/v2\/media?parent=2332"}],"wp:term":[{"taxonomy":"question-category","embeddable":true,"href":"https:\/\/computing.net\/answers\/wp-json\/wp\/v2\/question-category?post=2332"},{"taxonomy":"question_tags","embeddable":true,"href":"https:\/\/computing.net\/answers\/wp-json\/wp\/v2\/question_tags?post=2332"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}