Any of those help Unless you tell Excel, it tries to be "smart" with dates which means it will guess what the format is and how to display the converted date. In almost all cases, you don't want that. Such files will display differently on computers with different date formats or when users have changed the OS default (even some Americans prefer DD/MM/YY over the standard MM/DD/YY).
BASH/AWK how in a given text file replace all dates dd.mm.yyyy dates to dd month yy
Does that help as in the topic how to in given text file using bash/awk replace in file only dates in format date dd.mm.yyyy to date format dd month yyyy where month (like 02 to february etc) , You can use gnu awk's (gawk) time capabilities like this: