Forum Discussion

emmabellu's avatar
emmabellu
Copper Contributor
Aug 21, 2024

Dates format as wrong locale - need to change how it is recognised

Hi, I have dates that were added to my spreadsheet but it's in the wrong format (US format rather than UK) But it thinks they are UK dates so if I use More Number Formats, and change it between US ...
excel
emmabellu's avatar
emmabellu
Copper Contributor
Aug 21, 2024

SergeiBaklanI'm not too sure as I didn't add them in.  I think they came from a report downloaded from our website but would likely have been excel or csv

SergeiBaklan's avatar
SergeiBaklan
Diamond Contributor
Aug 21, 2024

emmabellu 

When most probably csv. Are you on Excel 365?

    • SergeiBaklan's avatar
      SergeiBaklan
      Diamond Contributor
      Aug 23, 2024

      emmabellu 

      For csv and 365 you may somehow prevent default conversion with these settings

       

      • afillloon's avatar
        afillloon
        Copper Contributor
        Sep 16, 2024
        That does not work when reopening a .csv file in Excel. It simply ignores the option.

Resources