Forum Discussion

Copper Contributor

Jan 26, 2022

How can i Hard format the date type

Hello there, i have an excel file of customers which i want to save as .xlsx and then import it to notion. Since i live in germany and the standard date format here is DD.MM.YYYY i need to change i...

excel

HansVogelaar

MVP

Jan 26, 2022

ReinholdBut

Excel will always display a date in the formula bar in the user's short date format, regardless of the date format displayed in the cell itself.

So today, you would see 26.01.2022 in the formula bar, but if you sent the workbook to me, I'd see 2022-01-26, and someone in the USA would see 1/26/2022.

If you use a date format marked with a * in the Format Cells dialog, the format in the cell will be adjusted to the user's system settings automatically.

ReinholdBut

Copper Contributor

Jan 26, 2022

HansVogelaar

Thanks for the insights.
I managed to accomplish my goal with your tip of setting the system date format to the USA format and then using the "text to column" function of excel.
With this i got a bland text that the other program, notion, was able to interpret.
But i can't believe this is the intended way of doing this.