how to change dates from exported spreadsheet in XL

I
Irfan Khan 👤 Member for 16 years 10 months
M
Mai Tawfeq 👤 Member for 16 years 3 months

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

V
Victor Egnora 👤 Member for 22 years 4 months

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

R
Rodel Marasigan 👤 Member for 19 years 7 months

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.

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