Website Upgrade Incoming - we're working on a new look (and speed!) standby while we finalise 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.

how to change dates from exported spreadsheet in XL

3 replies [Last post]
Mon, 2010-04-26 07:20
Irfan Khan
User offline. Last seen 27 weeks 3 days ago. Offline
Joined: 19 Jul 2009
Posts: 138
Groups: Civil Engineering
السلام عليكم ورحمة الله وبركاته

Hi to all,

i exported my project in Spreadsheet (XLS) format.

In that XL format the format of date is like that - ’9/3/2007 8:00:00 AM.

But i want to change these format in like this -
03-Sept-2007.

So from where i hv to change these dates from Primavera or XL.

regards,,,,

Top

Replies

Thu, 2010-10-14 12:32
#1
Mai Tawfeq
User offline. Last seen 9 years 40 weeks ago. Offline
Joined: 4 Mar 2010
Posts: 96
Groups: Civil Engineering, Women in Planning & Scheduling (WiPS)

dear vector:

the WBS column in one of the column unteachable at all ,this happened with me one time i lost the WBS the reasoned  by modifying in WBS column in EXL.

regards.

Mai

Top
Thu, 2010-10-14 12:21
#2
Victor Egnora
User offline. Last seen 4 years 24 weeks ago. Offline
Joined: 18 Jan 2004
Posts: 11
Groups: None

Hi Rodel,

Thanks for the tip, it spare us from lengthy process just to arrive on a proper date format.

Please share your wisdom on how to update a programme using excell, and how important are the templates. I tried it once but I messed up the WBS.

Thanks

Top
Mon, 2010-04-26 07:37
#3
Rodel Marasigan
User offline. Last seen 4 days 3 hours ago. Offline
Joined: 25 Oct 2006
Posts: 1699
Groups: Petro-Chem / Oil & Gas
Irfran,
Export files are in text format. If you need to change the format highlight the column that need to change then press ctrl+h (Replace Command) then enter ‘ on Find what text box and leave replace with blank then click replace all. Then press ctrl+1 (Format Cell command) then format it by date format you wanted.
Top