Forum Discussion

dmytro.korol's avatar
dmytro.korol
Copper Contributor
Sep 16, 2018

Why is excel cutting off seconds in a timestamp?

For example

 

2016-02-08 6:10:05

 

displays as 

 

2/8/16 6:10

 

when I paste it.

 

How do I change this default. I don't want manually go an change the date format every time have a new excel file.

No RepliesBe the first to reply

Resources