This project has moved. For the latest updates, please go here.

Zeroes stripped when reading phone numbers

Sep 25, 2014 at 12:30 PM
When I read an XLSX file with cells containing zeroes (for example 00359182), the zeroes get removed. How can I prevent this from happening?
Sep 25, 2014 at 12:31 PM
Found the solution: I used .Text instead of .Value. E.g:

object o = workBook.Worksheets[n].Cells[y,x].Text
Sep 30, 2014 at 7:02 AM
Right, it needs to be done everywhere with preceding zeros like zip codes, people's numbers and so on