- Kusonjululiwe
- Okugcinwe kunqolobane
Window 10 Firefox login table date scientific number conversion to Excel date numbers
Dear Sir or Madam; I downloaded a login CSV file from the Firefox browser. The date columns format in the CSV login file is ‘1.64055E+12’. In EXCEL, 44556.79166 would tr… (funda kabanzi)
Dear Sir or Madam; I downloaded a login CSV file from the Firefox browser. The date columns format in the CSV login file is ‘1.64055E+12’. In EXCEL, 44556.79166 would translate to 2021/12/26 18:59:59. The translation of ‘1.64055E+12’ should not be the same exact date, but should be in the same date range, as the 44556.79166 number. I’m not a mathematician. Would you please show me how to convert the '1.64055E+12' value to an equivalent excel date/time number? I could then format the excel date number cells to an yyyy/mm/dd hh:mm:ss format. These scientific number values are in the Firefox login file CSV downloads so I assume they were intended to be used in EXCEL spread sheet. These values converted to EXCEL date values would help me sort account password date change records by account name and change date. I could review sorted account records (and thus determine the current password for individual old accounts). Your solution would help me immensely and I appreciate your time. Sincerely, Clyde Stewart – wes45505@aol.com, Boise, ID