Panasonic Home Business > Industrial Devices > Automation Controls Top > Service & Support > Frequently Asked Questions

How do I display BCD?

ID:
849
Issued:
Dec 22nd, 2009
Updated:
May 17th, 2013

How do I display BCD?

ANSWER
To display and perform an operation in the same cell, use hexadecimal display for the cell data setting. However, in the case that there are fewer than four digits in the BCD display, (fewer than 8 digits for one or two word display), zeros are displayed in front of the other digits.

Example: PLC DT0 23 (HEX display) -> 0023 on the Excel spreadsheet

With the following method, it is possible to eliminate the leading zeros.

Example: PLC DT0 23(HEX display) -> 23 on the Excel spreadsheet

Setting method
1. Assuming 0023 is displays in the cell "A1" actually, you set the formula "VALUE(A1)" in the cell "A2" so that "A2" displays just '23' without '00'.

2. Input the following operator into the cell in the Excel spreadsheet where you want to display BCD.

Example: If A1 is the cell position, input: =VALUE(A1)
RELATED CATEGORIES

Did you solve your problems?

YES

NO

Search Keywords


If you still have problems with our products,

FEEL FREE TO CONTACT US

Return to top