convert to another date-format

New Contributor

I often select data from my bank-account and they use the date-format but to use dates to manage my data, I use the format dd-mm-yyyy. How to convert to this format in an easy way ?

I have used the search/change facility to convert all . to -, but it isn't a nice way. Can you help.


3 Replies
best response confirmed by ean-1501 (New Contributor)



Here's a formula that will convert your bank's dates (assuming they're in there as text) to a standard Excel formatted datevalue





It works - super

The Danish formulas have another structur with ; instead of , and the form had to be with rigth, mid and lest in the end before it worked. @ean-1501