Sorting numbers with #div/0! in column

Hi,

I have some numbers in a column which due to other cells not yet being filled in are returning a supressed #div/0! error. This is fine, but when i go to sort the column it puts them in the wrong order.

If it helps out any, I would like to record a macro, and assign it to the column header in order to sort the column.

Thanks