google sheets – How to sort a column with date as impeded within Texts?

I have a list of files’ names that I would like to sort based on the date that’s impeded within the file name text (Column A folder). When sorting them, the number 10 comes after 1 instead of 1,2,3,4,5….etc. So, I came up with a new column (G) that has the number of day only being extracted from the file name (Column A) by this formula:


But still I can’t sort the rows as expected… 10 comes after 1, 20 after 2 and 30 after 3.. Any idea how to solve this issue?enter image description here