Forum Discussion
Translating serial numbers into date codes
I have an excel file with a column with dates in the format dd.mm.yyyy. In some of the cells, there are more than one date or commas and semi commas. I want only to have ten digits counted from the l...
Better to use =VALUE(LEFT(A2;10)) and apply date format to your target column (I assume dd.mm.yyyy is your default date format)
