I am having an issue where excel is deleting the zeros at the end of a value,
so 10 is becoming 1. This was first seen in a macro where I run sort, but
happens if I just use the sort manually as well. I have gotten it to not
repeat manually, but it seems to always be doing it in the macro. Has anyone
ever seen this?

Here is the code used for sorting.

ActiveSheet.UsedRange.Sort Key1:=Cells(2, ccData1), Order1:=xlAscending,
Header:= _
xlGuess, OrderCustom:=ccData1, MatchCase:=False,
Orientation:=xlTopToBottom, _
DataOption1:=xlSortNormal

This is quite frustrating, so any help would be great. Thanks.