Certain Time Values in a .xlsx not Changing When I convert to a .csv

by Zain Raza   Last Updated July 12, 2019 15:01 PM - source

I am trying to convert from an Excel spreadsheet (.xlsx) file to a .csv file. The software I am using is Excel 2007. The issue I am having is I have a column of date and time values for every hour of every day, yet for some reason every 24th hour does not convert from the .xlsx to the .csv.

For example, one section of the column of my .csv says this:

screenshot of my .csv spreadsheet

1) So how would I change the cell in row 25 to follow the same 24 hour date time format as the rest of the cells in the column?

2) And could anyone please explain why it is converting from a date time in the .xlsx to this number in the .csv in the first place?

3) And is there a formula I could apply to Excel so that the rest of the 24-hour cells are also converted from .xlsx to .csv correctly as well?

Thanks so much!

Related Questions

Excel SUMIFS Formula Sequential Date Criteria?

Updated July 27, 2016 08:02 AM