Tips on using this forum..

(1) Explain your problem, don't simply post "This isn't working". What were you doing when you faced the problem? What have you tried to resolve - did you look for a solution using "Search" ? Has it happened just once or several times?

(2) It's also good to get feedback when a solution is found, return to the original post to explain how it was resolved so that more people can also use the results.

Export to Excel Without Time

2 replies [Last post]
Jacob Emmanuel
User offline. Last seen 7 years 6 weeks ago. Offline
Joined: 7 Nov 2008
Posts: 14
Groups: None
i want to export to excel without time in dates, i already ticked "dont show time" in edit menu-user preferences-dates tab, but the exported value still has time.



Barrie Callender
User offline. Last seen 1 year 19 weeks ago. Offline
Joined: 15 Feb 2006
Posts: 39
Groups: None
You could always just change the display format of the columns with Date and Time in them.
Sherif Fam
User offline. Last seen 9 years 39 weeks ago. Offline
Joined: 17 Apr 2005
Posts: 28
Groups: None

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.