Number format problem

Hi. I attached an excel spreadsheet made for calculation purposes. I import data from a software in Excel through DDE. The problem is at page 2(Symbols), the data is imported in the format 0.XXXX , and I cannot make any calculation with it as it gives #VALUE! error. I tried custom formatting without success. Can anyone help me convert that numbers in the form X,XXXX ? Thank you!