Excel online keeps changing my date











up vote
1
down vote

favorite












So here is the problem, when I typed 08/03/2018 it changes automatically to 03/08/2018. Why? I set the number format for the whole column to date (Indonesian) dd/mm/yyyy.



Any help would be appreciated






microsoft-excel microsoft-office







share|improve this question




















  • 1




    Go to Online Region setting and change the Region as the same as your local regions settings. Refer to this support article: support.office.com/en-us/article/…
    – Lee
    Nov 22 at 3:19










  • thanks @Lee i'll try this
    – Agil GA
    Nov 22 at 3:21










  • @Lee You mean changing the region in onedrive? i cant do that, the account isnt mine
    – Agil GA
    Nov 22 at 6:22










  • @AgilGA,, do this trick. Select the entire data range and apply dd/mm/yyyy forrmat. Now,, while you type Date Value type 11/22/18 (i.e. Month/Date/Year) Excel will convert the Date Value to 22/11/2018 and that's what you need.
    – Rajesh S
    Nov 22 at 12:12

















up vote
1
down vote

favorite












So here is the problem, when I typed 08/03/2018 it changes automatically to 03/08/2018. Why? I set the number format for the whole column to date (Indonesian) dd/mm/yyyy.



Any help would be appreciated






microsoft-excel microsoft-office







share|improve this question




















  • 1




    Go to Online Region setting and change the Region as the same as your local regions settings. Refer to this support article: support.office.com/en-us/article/…
    – Lee
    Nov 22 at 3:19










  • thanks @Lee i'll try this
    – Agil GA
    Nov 22 at 3:21










  • @Lee You mean changing the region in onedrive? i cant do that, the account isnt mine
    – Agil GA
    Nov 22 at 6:22










  • @AgilGA,, do this trick. Select the entire data range and apply dd/mm/yyyy forrmat. Now,, while you type Date Value type 11/22/18 (i.e. Month/Date/Year) Excel will convert the Date Value to 22/11/2018 and that's what you need.
    – Rajesh S
    Nov 22 at 12:12















up vote
1
down vote

favorite









up vote
1
down vote

favorite











So here is the problem, when I typed 08/03/2018 it changes automatically to 03/08/2018. Why? I set the number format for the whole column to date (Indonesian) dd/mm/yyyy.



Any help would be appreciated






microsoft-excel microsoft-office







share|improve this question















So here is the problem, when I typed 08/03/2018 it changes automatically to 03/08/2018. Why? I set the number format for the whole column to date (Indonesian) dd/mm/yyyy.



Any help would be appreciated






microsoft-excel microsoft-office




microsoft-excel microsoft-office






share|improve this question















share|improve this question













share|improve this question




share|improve this question








edited Nov 22 at 4:19









Aulis Ronkainen

6151514




6151514










asked Nov 22 at 3:10









Agil GA

212




212








  • 1




    Go to Online Region setting and change the Region as the same as your local regions settings. Refer to this support article: support.office.com/en-us/article/…
    – Lee
    Nov 22 at 3:19










  • thanks @Lee i'll try this
    – Agil GA
    Nov 22 at 3:21










  • @Lee You mean changing the region in onedrive? i cant do that, the account isnt mine
    – Agil GA
    Nov 22 at 6:22










  • @AgilGA,, do this trick. Select the entire data range and apply dd/mm/yyyy forrmat. Now,, while you type Date Value type 11/22/18 (i.e. Month/Date/Year) Excel will convert the Date Value to 22/11/2018 and that's what you need.
    – Rajesh S
    Nov 22 at 12:12
















  • 1




    Go to Online Region setting and change the Region as the same as your local regions settings. Refer to this support article: support.office.com/en-us/article/…
    – Lee
    Nov 22 at 3:19










  • thanks @Lee i'll try this
    – Agil GA
    Nov 22 at 3:21










  • @Lee You mean changing the region in onedrive? i cant do that, the account isnt mine
    – Agil GA
    Nov 22 at 6:22










  • @AgilGA,, do this trick. Select the entire data range and apply dd/mm/yyyy forrmat. Now,, while you type Date Value type 11/22/18 (i.e. Month/Date/Year) Excel will convert the Date Value to 22/11/2018 and that's what you need.
    – Rajesh S
    Nov 22 at 12:12










1




1




Go to Online Region setting and change the Region as the same as your local regions settings. Refer to this support article: support.office.com/en-us/article/…
– Lee
Nov 22 at 3:19




Go to Online Region setting and change the Region as the same as your local regions settings. Refer to this support article: support.office.com/en-us/article/…
– Lee
Nov 22 at 3:19












thanks @Lee i'll try this
– Agil GA
Nov 22 at 3:21




thanks @Lee i'll try this
– Agil GA
Nov 22 at 3:21












@Lee You mean changing the region in onedrive? i cant do that, the account isnt mine
– Agil GA
Nov 22 at 6:22




@Lee You mean changing the region in onedrive? i cant do that, the account isnt mine
– Agil GA
Nov 22 at 6:22












@AgilGA,, do this trick. Select the entire data range and apply dd/mm/yyyy forrmat. Now,, while you type Date Value type 11/22/18 (i.e. Month/Date/Year) Excel will convert the Date Value to 22/11/2018 and that's what you need.
– Rajesh S
Nov 22 at 12:12






@AgilGA,, do this trick. Select the entire data range and apply dd/mm/yyyy forrmat. Now,, while you type Date Value type 11/22/18 (i.e. Month/Date/Year) Excel will convert the Date Value to 22/11/2018 and that's what you need.
– Rajesh S
Nov 22 at 12:12

















active

oldest

votes











Your Answer








StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "3"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);

StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});

function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});


}
});














 

draft saved


draft discarded


















StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fsuperuser.com%2fquestions%2f1377460%2fexcel-online-keeps-changing-my-date%23new-answer', 'question_page');
}
);

Post as a guest















Required, but never shown






























active

oldest

votes













active

oldest

votes









active

oldest

votes






active

oldest

votes
















 

draft saved


draft discarded



















































 


draft saved


draft discarded














StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fsuperuser.com%2fquestions%2f1377460%2fexcel-online-keeps-changing-my-date%23new-answer', 'question_page');
}
);

Post as a guest















Required, but never shown





















































Required, but never shown














Required, but never shown












Required, but never shown







Required, but never shown

































Required, but never shown














Required, but never shown












Required, but never shown







Required, but never shown







-

Popular posts from this blog

Probability when a professor distributes a quiz and homework assignment to a class of n students.

Image
0 0 $begingroup$ Need help with this problem. Suppose our lazy professor collects a quiz and a homework assignment from a class of n students one day, then distributes both the quizzes and the homework assignments back to the class in a random fashion for grading. Each student receives one quiz and one homework assignment to grade. (a) What is the probability that every student receives someone else's quiz to grade, and someone else's homework to grade? (b) What is the probability that no student receives both their own quiz and their own homework assignment to grade? In this case, some students may receive their own quiz, and others may receive their own homework assignment. (c) Compute the limiting probability as n approaches infinity in each case. ...
Read more

Aardman Animations

Image
Aardman Animations, Ltd. Aardman Animations Tipo privada Atividade Animação em stop-motion , Animação em CGI Fundação 1972 Fundador(es) Peter Lord David Sproxton Sede Bristol, Inglaterra  Reino Unido Proprietário(s) Dreamworks Pessoas-chave Peter Lord David Sproxton Nick Park Divisões Aardman Features Aardman Digital Aardman Commercials Aardman Broadcast Aardman International Aardman Rights Aardman Effects Aardman 3-D Systems Aardman Nathan Love AardBoiled Website oficial aardman.com ...
Read more

Are they similar matrix

Image
0 $begingroup$ Do $begin{bmatrix} 0&i&0\0&0&1\0&0&0 end{bmatrix} $ and $begin{bmatrix} 0&0&0\-i&0&0\0&1&0 end{bmatrix} $ are similar.Is this True/false Clearly both are nilpotent and one is conjucate transpose of other but how to know if they are similar.i'm stuck. Please help me linear-algebra vector-spaces eigenvalues-eigenvectors generalizedeigenvector share | cite | improve this question edited Dec 10 '18 at 6:38 Vasanth Kris asked Dec 10 '18 at 6:19 ...
Read more