When saving the CSV file, the 0 in front of the text was lost

  1. I build datatable and add only one row with text value “0234”
  2. I save as CSV file, however, the column value missing 0 as below:

Hi,

For now, can you check content of the csv file using text editor such as notepad?
I guess csv file keeps 0 and the above is excel matter.

Regards,

1 Like

@Lori

Add a special character (like a single quote ') before the values with leading zeroes. This forces Excel to interpret the values as text.

For example like this '0234

1 Like

@Lori

If you open in notepad …mostly you shpuld be able to still see 0

Cheers

Hello @Lori,

If you change the Excel column format to ‘Text’ it will work.

Thanks

Yeah, when I open as notepad, same as you mention, thanks.

1 Like

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.