Forum Discussion

411011890's avatar
411011890
Copper Contributor
Jul 13, 2022

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...
excel
Excel for web
SergeiBaklan's avatar
SergeiBaklan
Diamond Contributor
Jul 13, 2022

411011890 

You may change your Windows regional settings, or apply custom format to your cells like

wlb729attnet's avatar
wlb729attnet
Copper Contributor
Jul 15, 2022
I want to have it look like 10-10-2010, not 10/10/2010
  • SergeiBaklan's avatar
    SergeiBaklan
    Diamond Contributor
    Jul 16, 2022

    wlb729attnet 

    You may apply dd-mm-yyyy format or to change short data format in regional setting for your Windows

    Similar on Mac.