I hope someone can help. We use Q-Pulse and it resides on a server in Denmark. When we pull data from it the date format is in Danish D/M/Y. When bring into excel in USA this column changes into 2 layout. One is M/D/Y and the other is D-M-Y. Is there a simple way to get all this into the same format. I have tried to search and replace and text to columns. but both are very time consuming. Anyone have a suggestion?