Hey I have the following issue after converting a csv into regular excel: some of the values (that are supposed to be amounts) , are there as dates, example 11.31 has been converted into Nov 31 BUT if I change the format to number of text then I get the 11628. What can I do? R...
If I understand your task correctly, the following formula should work for you: =DATE(LEFT(D1,4),MID(D1,6,2),MID(D1,9,2)) I don't know which date formal you are using. Therefore, you may find it useful to know how to convert text to date. Reply Thomas...
import requests import os with open('files/mv.csv', mode='r', encoding='utf-8') as file_read: file_read.readline() # 跳过第一行 for line in file_read: content = line.split(',') file_name = content[1] file_url = content[2].strip() res = requests.get(url=file_url, headers...