1904 not transferring to online worksheet

Copper Contributor

I created a desktop worksheet using 1904 dating system. I moved it to the online version as to collaborate but then the 1904 system reverts back and my minus numbers appear as an error. i dont have advanced options on the online version to change it back. Is there a fix? Thanks

4 Replies

@Paul19851985 

It looks like Excel Online doesn't support the 1904 date system, so I fear you're out of luck.

You might post a suggestion on the Excel Feedback Portal 

@Hans Vogelaar  Thanks for your reply. 

@Hans Vogelaar 

Even better if both Windows and web will support negative time (or duration) without 1904 system.

@Sergei Baklan 

That would be very helpful, but I don't think Microsoft will do that...