Formatting data input in order to use predefined macro

Hi all,

I'm posting this in addition to

HTML Code: 

.

We have currently implemented a new ERP system, and the data format input i get from this new ERP system is different from the old ERP system. The result is that my macro can not align the account numbers, and therefore puts it at the end of the rows.

My question is: "How do i format the data input(/macro) such that i'm able to align these accountnumbers again?"

Macro used:

Please Login or Register  to view this content.

See attached (sheet1 working, sheet2 non-working) for example Column A is the master accountnumber which is to be aligned with column C (and number in column D)

I believe this is quite simple, however i'm not able to fix the problem (have tried to format column C to the format of column A (NOT WORKING), and formatting the entire sheet as text (NOT WORKING) :-()

Thanks in advance!