Forum Discussion
411011890
Jul 13, 2022Copper Contributor
Cell values being stored as Text
Hi all, I’m having an issue where when changing the time in a cell, Excel stores the value as text rather than a date and messes up the formatting. See below for example. Steps I took: I...
wlb729attnet
Jul 15, 2022Copper Contributor
I want to have it look like 10-10-2010, not 10/10/2010
SergeiBaklan
Jul 16, 2022Diamond Contributor
You may apply dd-mm-yyyy format or to change short data format in regional setting for your Windows
Similar on Mac.