Let me be a little more clear. I'm getting a number in decimal from CLX that represents an Ascii text. When you change the data style in the monitor tag you can see the Ascii. Ex, 17323 is CO in Ascii. Can this be done in Excel?
I have created a spread sheet to track paper rolls as they move down the wharehouse. I am getting data from a ControlLogix processor via RSLinx and Topic Configuration. The problem is that I can display the roll order number in 5 cells as decimal numbers from the CLX but it represents an Ascii code.
Ex. Roll # CO 3G 03 06 3A is displayed in excel as 17200 13127 12339 12342 13121. Is there a formula function that can convert the decimal #'s so I can see the actual roll number in Ascii?
It's what the guy that programmed it used. I'm a troubleshooter trying to figure out where the data for the rolls are getting screwed up. The Exces spreadsheet I made has helped me find 6 errors in the code so far.