I've got one excel file that when I open it in the dropbox app, to preview it, shows all of the dates as the serialised numbers that excel stores them in.
Is there any way to view the dates as actual dates, I've tried adjusting the formatting of the cells - to date or custom, and neither seems to work.
Rather weirdly on the second sheet of the document, where I have calculated dates, they show up perfectly in the iOS Dropbox Preview - I'm a little bit confused as to what the issue would be. Again these cells are formatted as "Date".
When I open the same file through the dropbox web interface to preview it on my mac the dates show correctly. When I open the same file through the dropbox app on my iphone the dates show as "serialised numbers". I've attached images below:
Sadly it doesn't appear to fix anything, I've tried various date formats, and even changing between UK and USA regions to see if that helps, but nothing....
Interestingly if I click "open in excel" from the dropbox ios app - it displays perfectly, it would be great however if I didn't have to always do this extra step.
I do have a similar problem. Previewing an excel in the DropboxApp on Android shows dates in MM-DD-YYYY. Opening this in excel shows DD-MM-YYYY and that is what I want. Mixing these two date formats is confusing and is a source of mistakes. Please help me in solving this.
Hi there @GertvdK, thanks for nudging us on this thread.
Just to make sure we're on the same page, are you previewing these Excel docs via the website or the mobile app? Do you get the same experience if you export it and preview it locally on your device?
Keep me posted!
@Lusil Thanks for asking!
I am using the mobile app.
I exported the file. If I select the downloaded file it immediately opens excel (corrrectly), but I do not have or somehow bypass a previewmode. So I do not have the answer on your second question.
Thanks for getting back to me, @GertvdK.
I tried this out too, and I'm able to get the same date format I chose (when I edited the file locally on my computer) to show up on my mobile app.
If you've made sure that the date format is correctly saved on your computer, could you send me a screenshot (without any personal info) of what you see when you open the file on your mobile app and the desktop app?
For more info on available support options, see this article.
If you found the answer to your question, please 'like' the post to say thanks to the user!