Resoure Loading Report RL-02

R
Rodel Marasigan 👤 Member for 19 years 7 months

Hi Michael,



Check your Regional and Language Option settings. P3 export d/mm/yy format and MS Excel follow Regional and Language Option Settings.



Also CSV is a comma delimited text file and date is converted by Excel if readable as date but if started as a space then it will read by Excel as text. Try to highlight all the date fields on your Excel and press Ctrl+H or Select Edit-> Replace on Excel menu. Enter a space (press space bar) on “Find what:“ and click “Replace All”. That should remove all the space on the dates and Excel will automatically read it as a date.



Regards,

Rodel

Forum Sponsor

Top Posters

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
Manny Onifade
5 posts