Website Upgrade Incoming - we're working on a new look (and speed!) standby while we deliver the project

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]
Wed, 2009-04-08 23:51
Jacob Emmanuel
User offline. Last seen 10 years 49 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.

thanx
Top

Replies

Thu, 2009-04-09 10:54
#1
Barrie Callender
User offline. Last seen 1 year 33 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.
Top
Thu, 2009-04-09 09:51
#2
Sherif Fam
User offline. Last seen 13 years 31 weeks ago. Offline
Joined: 17 Apr 2005
Posts: 28
Groups: None
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
Top