Home
Join
check
  • Have you checked the date format within the Windows setting on the computer?  We get our computer images from Europe and the date format they have as the default within the Windows settings always causes us grief when a new image is distributed to the North American sites.

    I'm not sure if Excel reads the Windows default date format or if it can be overridden within Excel by changing the column format.

    Pepper graySpice (3) flagReport
    1 found this helpful thumb_up thumb_down
  • View Best Answer in replies below

    3 Replies

    • Have you checked the date format within the Windows setting on the computer?  We get our computer images from Europe and the date format they have as the default within the Windows settings always causes us grief when a new image is distributed to the North American sites.

      I'm not sure if Excel reads the Windows default date format or if it can be overridden within Excel by changing the column format.

      Pepper graySpice (3) flagReport
      1 found this helpful thumb_up thumb_down
    • Worked a treat, thank you very much!

      Seems very counter intuitive to even allow the changing of date formats if the system will simply overwrite. It was a CSV file, not sure if that makes a difference, will do some further testing.

      Was this post helpful? thumb_up thumb_down
    • Matty M. wrote:

      Worked a treat, thank you very much!

      Seems very counter intuitive to even allow the changing of date formats if the system will simply overwrite. It was a CSV file, not sure if that makes a difference, will do some further testing.

      That is most likely why.  Csv's don't retain formatting information.  They are simple plain text docs.

      Was this post helpful? thumb_up thumb_down

    Read these next...