I have written a program the logs thermal data from a PLC
to a separate excel sheet. The PLC logs the data as a
three place whole number (i.e. 639 = 63.9°F), so I
modified the code to reflect the conversion to a 2 place
decimal(i.e. Tag1 / 10) and formatted the columns to
reflect the same. The problem I have is that when it
throws the data into the sheet, it is rounding the
numbers (i.e 639 =64.00°F). Is there a way that I can
reset this to show the actual (63.9)?


Thanks in advance,

John Petty

P.S. I am using Excel 2002 (XP)