View original (French)

Téléchargement CSV en XLS/XLSX

y.bassir Posted messages 1 Registration date   Status Member -  
CalicoJack Posted messages 48 Status Member -
Hello,

I have a problem downloading CSV files in Excel format.

In the cells, I often have alphanumeric codes that lose their values in Excel.

Thank you for helping me download in Excel format while keeping their values in the cells.

Regards.
Configuration: Windows XP Firefox 2.0.0.9

1 answer

  1.
    CalicoJack Posted messages 48 Status Member 29
     
    For example, you have numbers like 00034534 that you want to keep the zeros?

    When you import the CSV file into Excel, make sure to choose the data type for each column correctly. A text column does not allow calculations but preserves the leading zeros, or any characters.
    0