Question

csv date automatic conversion

  • 14 April 2024
  • 2 replies
  • 31 views

Badge +3

when iam saving 2023-09-08 in csv format.

It is automatically saving to different date format


How to stop automatic conversion.


2 replies

Badge +3

Can someone please reply on this

Userlevel 3
Badge +10

I’m not an excel expert, but I believe you will need to first set a specific format for that column or cell you paste date data into to make sure the format stays the way you want. For 2023-09-08 you will need to pick “text” format. 

Reply