Export to Excel Without Time

2
27141 👤 Member for 17 years 8 months
B
Barrie Callender 👤 Member for 20 years 5 months

You could always just change the display format of the columns with Date and Time in them.

S
Sherif Fam 👤 Member for 21 years 3 months

Hi,



I encountered the same situation before. The fastest walk-around is to modify it in Excel.



- Insert a new column in Excel (let’s say C); just after the dates and times column (let’s say B).



- Make the new column as a formula "C1=Left(B1,10)"



This operation will cut the unwanted time info; and you will e left with dates only.



Regards,



Sherif

Featured Partner

Top Posters

Zine Eddine
2 posts
Alex Lyaschenko
27 posts
mxsiegel
0 posts
Mattvtek
0 posts
Gareth Evans
3 posts
PP Admin
3, 129 posts
Rajkamal Tangirala
5 posts
Rahul Kumar
1 posts
blake333_
0 posts
Jeamiell Ostrovsky
2 posts