Forum Discussion
AI242
Oct 20, 2021Copper Contributor
Microsoft excel and outlook version 2016
Hi,When I recieved the data in google sheet the date appears the same as the sender but when I downloaded as excel or open it on outlook its changing for example: In google sheet 03/04/2021 it means ...
SergeiBaklan
Oct 23, 2021Diamond Contributor
It depends on regional format setting in your Google Sheets environment and for environment where you use Excel.
- AI242Oct 23, 2021Copper ContributorThank you
But I don't need to use Google sheet I need only outlook and excel
And it doesn't make sense when I recieved mail to call the sender and ask him about the region or the settings of his PC
No matter what I put the settings in my laptop
I need to see the date in the excel sheet as the sender send it- PeterBartholomew1Oct 23, 2021Silver Contributor
If an American sends you a message with date 3/4/2012 as text, there is no way of knowing whether he is using the US system (March 4) or has converted it for the recipient (3 April); though unjustified stereotyping might suggest the former. If the date is an Excel serial number, the conversion between systems takes place automatically.