Macro sort issue

[Dan Wilson]

Good day. I am running Excel out of Office 365 on Windows 10. I have a worksheet that contains user entered data in Column F and a formula in Column G. There are two identical macros that sort the data in these two columns. The only difference between the macros is that one references Column F and the other Column G. Columns F and G are both formatted as Data with no decimal points. Column F is user entered data, Column G is calculated. When I run the Column F sort, all is well and the data is sorted in descending order. When I run the Column G sort, the data is sorted showing all "0" calculations first, then the remainder in descending order. Even when I do a manual sort using the Developer Sort function, the results are the same. What am I doing wrong? Any help is appreciated.
Thanks, Danno...

 

[mole999]

what is your G calculation

 

[steve the fish]

No doubt your formula contains "0" which is textual so is greater than a number. Remove those inverted commas if you want "0" to truely be 0.

 

[Dan Wilson]

Good day mole9999 and steve the fish. Steve, your reply was the one that fixed the problem. Mole, I'm sure that had I answered your reply, you would have had the same answer. That is so simple. I did not know that "0" was different from 0. Now I have a ton of editing to do to fix that problem in other macros and formulas on the worksheets. This forum is the BEST!
Thanks, Danno...

 

[mole999]

on a copy, just test find replace and see if you can do it quicker

 

[Dan Wilson]

Thank you Mole9999. I am very familiar with editing shortcuts. I just have a lot of worksheets to check and edit.
Thanks, Danno...

 

[steve the fish]

Assuming the "0" are mostly in the formulas as ,"0" you could try this:

For Each sh In ThisWorkbook.Worksheets
    sh.Cells.Replace What:=",""0""", Replacement:=",0", LookAt:=xlPart
Next

 

[Dan Wilson]

Thank you Steve, I'll put that code in my Excel Notes for future use. Looks like an easy way to edit several macros at the same time.
Thanks, Danno...