Forum Discussion

jeff-125's avatar
jeff-125
Copper Contributor
Feb 24, 2023

Automatic Date Format When Generating a CSV from Software

Hello,   When I generate a .CSV of data from my database I am getting an automatic format change to DATE in a column that contains a dashed numbering system used in my database. Ex:  5-12-01    I...
excel
tauqeeracma's avatar
tauqeeracma
Iron Contributor
Feb 26, 2023

HIjeff-125 

 

There is one possibility if you import CSV data into excel and while importing select the TEXT format as mentioned below, your data may not change into the date format.

 

 

Hope it will help.

 

Thanks

Tauqeer

  • jeff-125's avatar
    jeff-125
    Copper Contributor
    Feb 27, 2023
    Thank you for your response!

    I will try this.

Resources