0

i was new about edit format excel data. i have problem with remove time(HH:MM:SS sss.ss) from my date data, and edit my value data to decimal format

enter image description here

i was planning make date > 15/05/2017 and waktu_eod_per_menit > 13,58

There a lot data for me to edit like that, i was have doing step normal formatting ( choice format cells, and choice the format i want) but the data didnt change.

enter image description here

Please help me about this

Thanks

Scott Craner
  • 148,073
  • 10
  • 49
  • 81
Toshi Mario
  • 3
  • 2
  • 2
    Those dates are probably stored as text and not a true date, which is why you cannot format it properly. There are many answers on this board on how to make it a true date in mass. – Scott Craner Feb 01 '23 at 23:26

0 Answers0