Cara Mengatasi Format Tanggal Tidak Terbaca di Excel
Radial-Tutorial
[{'start': '1.000', 'end': '11.000', 'text': "Excel Can't Read Dates from Other Files? Try This Trick!"}, {'start': '11.015', 'end': '14.115', 'text': "Because the data isn't in Excel date format"}, {'start': '14.240', 'end': '22.240', 'text': "Ever found data from outside that can't be calculated in Excel?"}, {'start': '27.640', 'end': '35.640', 'text': 'For example: January 23, 2024, but Excel doesn’t treat it as a date?'}, {'start': '40.400', 'end': '43.400', 'text': 'Don’t worry, in this video we’ll show you'}, {'start': '43.424', 'end': '47.524', 'text': 'how to convert everything into valid dates'}, {'start': '47.600', 'end': '50.600', 'text': 'in just a matter of seconds!'}, {'start': '53.240', 'end': '56.240', 'text': 'This is data imported from another system'}, {'start': '56.264', 'end': '60.264', 'text': 'here we have date data and we want to use it'}, {'start': '60.288', 'end': '63.288', 'text': 'for further analysis, but the problem is...'}, {'start': '77.200', 'end': '82.200', 'text': 'Let’s try using ISNUMBER() and YEAR() functions to check'}, {'start': '82.224', 'end': '87.224', 'text': 'Does Excel recognize it as a date?'}, {'start': '116.800', 'end': '121.800', 'text': 'Turns out Excel doesn’t recognize this data as a date,'}, {'start': '121.824', 'end': '128.824', 'text': 'The result from ISNUMBER() and YEAR() is False and Error'}, {'start': '142.800', 'end': '145.800', 'text': 'Now, how do we make Excel recognize it as a date?'}, {'start': '145.824', 'end': '148.824', 'text': 'Keep watching tutorials like this'}, {'start': '148.848', 'end': '151.848', 'text': 'by pressing the subscribe button...'}, {'start': '163.200', 'end': '171.200', 'text': 'Okay, let’s start so that our data can be recognized as a date by Excel'}, {'start': '180.000', 'end': '182.400', 'text': 'First step, open "Control Panel"'}, {'start': '186.240', 'end': '188.240', 'text': 'Select Region'}, {'start': '202.000', 'end': '204.600', 'text': 'On the \'Formats\' tab, choose "Indonesia"'}, {'start': '208.000', 'end': '210.000', 'text': 'Click "Apply"'}, {'start': '212.140', 'end': '214.140', 'text': 'Click OK'}, {'start': '220.400', 'end': '223.400', 'text': 'Now, close Excel and reopen it to see the effect of the settings'}, {'start': '223.424', 'end': '226.424', 'text': 'Keep watching the latest tutorial videos like this one'}, {'start': '226.448', 'end': '231.448', 'text': 'by pressing the subscribe button...'}, {'start': '235.720', 'end': '243.720', 'text': 'Now this data is already read as a date by Excel'}, {'start': '245.940', 'end': '247.940', 'text': 'Double-click on the date cell'}, {'start': '253.300', 'end': '261.300', 'text': 'This shows the data is now read as a date by Excel'}, {'start': '268.240', 'end': '272.240', 'text': 'But double-clicking each cell'}, {'start': '272.264', 'end': '276.264', 'text': 'isn’t possible if there are thousands of rows'}, {'start': '278.880', 'end': '286.880', 'text': 'A faster way is to use "Paste Special Multiply"'}, {'start': '292.000', 'end': '293.600', 'text': 'Type the number 1 in an empty cell'}, {'start': '297.640', 'end': '299.640', 'text': 'Then Copy it, press Ctrl+C on your keyboard'}, {'start': '304.800', 'end': '306.800', 'text': 'select the data range'}, {'start': '311.400', 'end': '313.400', 'text': 'Right click'}, {'start': '314.240', 'end': '316.240', 'text': 'Choose "Paste Special..."'}, {'start': '318.640', 'end': '320.640', 'text': 'Select "Multiply"'}, {'start': '322.640', 'end': '324.640', 'text': 'Click OK'}, {'start': '326.440', 'end': '328.440', 'text': 'Select date format'}, {'start': '335.400', 'end': '341.000', 'text': 'Everything is now in a valid date format'}, {'start': '341.024', 'end': '343.024', 'text': 'or choose "More Number Format"'}, {'start': '351.800', 'end': '359.800', 'text': 'Now you can use it for Excel operations that require date formats'}, {'start': '368.000', 'end': '370.400', 'text': 'If you find this video useful!'}, {'start': '370.424', 'end': '373.224', 'text': 'Don’t forget to give it a thumbs up, then share and subscribe'}, {'start': '373.248', 'end': '375.248', 'text': 'and leave your comments below...'}, {'start': '381.400', 'end': '383.400', 'text': 'That’s all for this tutorial video...'}, {'start': '383.424', 'end': '385.424', 'text': 'Hope it’s helpful...'}, {'start': '385.448', 'end': '387.448', 'text': 'See you in the next video...'}]