how to change dates from exported spreadsheet in XL
Forum Sponsor
Top Posters
EViLL1
1 posts
Dimitrios Theocharidis
3 posts
MichaelFuelsC
0 posts
anwar zeb
1 posts
olva seselima
1 posts
Muhammd Muneer
0 posts
sairam
0 posts
MARAT BILYALOV
0 posts
RichTea66
0 posts
Muneer Muhammad
1 posts
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
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
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.