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

How do I know what Microsoft account the skydrive app is syncing to?

Image
up vote 4 down vote favorite 1 Some time ago, I set up skydrive for my wife on her mac. But now she wants to access the files online, I cannot remember what Microsoft account I setup and linked her skydive app to and nor can I see anything in the skydrive app settings to tell me either? How can I see the name of the Microsoft account the skydive app is currently linked to? I would like to know this for skydrive app for Mac and PC onedrive share | improve this question asked Feb 25 '13 at 4:52 Gary Barrett 260 2 5 12
Read more

Grease: Live!

Image
A tradução deste artigo está abaixo da qualidade média aceitável. É possível que tenha sido feita por um tradutor automático ou por alguém que não conhece bem o português ou a língua original do texto. Caso queira colaborar com a Wikipédia, tente encontrar a página original e melhore este verbete conforme o guia de tradução. Grease: Live! Grease: Live!  (PRT/BRA)  Estados Unidos 2016 •   cor •   130 min. min   Direção Thomas Kail Alex Rudzinski Produção Marc Platt Adam Siegel Roteiro Allan Carr Robert Cary Warren Casey Jim Jacobs Jonathan Tolins Bronte Woodard Baseado em Grease (musical) Grease (filme) Elenco Julianne Hough Aaron Tveit Vanessa Hudgens Carlos Pena Jr. Keke Palmer Carly Rae Jepsen Kether Donohue Jordan Fisher David Del Rio Andrew Call Gênero Musical Música Tom Kitt Figurino William Ivey Long Companhia(s) produtora(s) Warner Bros. Studios Distribuição Fox Lançamento 31 de Janei
Read more

When does type information flow backwards in C++?

Image
up vote 62 down vote favorite 19 I just watched Stephan T. Lavavej talk at CppCon 2018 on "Class Template Argument Deduction", where at some point he incidentally says: In C++ type information almost never flows backwards ... I had to say "almost" because there's one or two cases, possibly more but very few . Despite trying to figure out which cases he might be referring to, I couldn't come up with anything. Hence the question: In which cases the C++17 standard mandates that type information propagate backwards? c++ language-lawyer c++17 share | improve this question edited 7 hours ago scohe0
Read more