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
SergeiBaklan's avatar
SergeiBaklan
Diamond Contributor
Aug 21, 2024

emmabellu 

How these dates are added, do you open csv file to take them?

  • 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?

Resources