Im making a web app where the users can import a spreadsheet to do mass updates. I created two different templates for two different types of users but both are essentially the same. There is one row that contains dates (ex: 10/1/2008) and i need to know which month/date i am updating. In both spreadsheets both cells are formatted the exact same way(Date) and both contain the exact same date values but when i go to import them in my application one spreadsheet reads it as the OA date(decimal) and the other reads it as a plain text (10/1/2008). So when i go to convert to datetime i do not know which conversion to use. Both are .xlsx format. I dont understand why both are not being read in as the same format.
im not too good with excel so is there a way to force a cell to always be a certain format?
Start Free Trial
