Then apply the formula as suggested in the first row:

=A1/0.57

Then select the cells that need the formula, eg down the column, select as a block and Press Ctrl + D to fill down the column. This will only populate the visible ones.

You can then reset the filter to show all and copy the formula column and paste values onto the original column.

Thanks

Rob H