Hello All

  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?  Please keep in mind that I am new to using Excel so I tend to stay confused!

Thanks Steve

Let's say the five decimal numbers are in A1:E1.

In A2, enter the formula

=CHAR(A1/256)&CHAR(MOD(A1,256))

You can copy or fill this formula to E2.