Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
rounding of numbers in vba
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) |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
rounding of numbers in vba
Are you sure your variable that holds the data isn't dimmed as long or
integer. Make sure it is double or single. -- Regards, Tom Ogilvy "john petty" wrote in message ... 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) |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
rounding of numbers in vba
Are you saving the values in an integer variable before
you put them in the cell? That could be the culprit. Also are you rounding before you put the values in the cell in VBA? Try reformating the whole sheet back to general and then start the formatting over. Hope that helps. Keith www.kjtfs.com -----Original Message----- 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) . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Rounding Numbers. | Excel Worksheet Functions | |||
rounding numbers | Excel Worksheet Functions | |||
Rounding Numbers | Excel Discussion (Misc queries) | |||
Rounding Numbers | Excel Discussion (Misc queries) | |||
Rounding numbers then doing a sum of those numbers produces incorrect result. | Excel Programming |