boycoto

boycoto

  • NA
  • 147
  • 125.5k

zeroes ommitted in the ID column

Aug 5 2012 11:15 PM
I have csv file that if I open it using EXCEL file, it ommitted the zeroes at the begginning of the text whereas if I am going to view using notepad, the ID is correct.  For example, the value of the ID is 000102233, if I am going to view it using Excel it displays as 112233, which is also the value that my program gets if I extract it from the csv file and store it to database. How am I going to deal with it?

Answers (4)