The following table shows which percent codes are valid for each data type. If a cell contains X, the format is invalid for that data type. If the cell contains , setting the format of a double-precision, floating-point data type to absolute time is valid, but when you change the double-precision, floating-point data type to a long signed integer data type, the format changes to decimal format.
| Percent Code Format | T |
t |
x |
o |
b |
d |
u |
f |
e |
g |
p |
# |
^ |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Data Types |
Absolute Time |
Relative Time |
Hexadecimal |
Octal |
Binary |
Signed |
Unsigned |
Floating- Point |
Scientific Notation |
Scientific Notation or Floating-Point, Based on Exponent |
SI Prefix |
Auto Precision (Remove Trailing 0s) |
Engineering Notation |
| Time Stamp | ![]() |
X | X | X | X | X | X | X | X | X | X | X | X |
| Complex types (CXT, CDB, CSG) | X | X | X | X | X | -+ |
-+ |
![]() |
![]() |
![]() |
![]() |
![]() |
![]() |
| Real floating-point types (EXT, DBL, SGL) | -+ |
-+ |
X | X | X | ![]() |
-+ |
-+ |
![]() |
![]() |
![]() |
![]() |
![]() |
| Integer types (U64, I64, U32, I32, U16, I16, U8, I8) | -+ |
-+ |
![]() |
![]() |
![]() |
![]() |
![]() |
-+ |
-+ |
-+ |
-+ |
-+ |
-+ |
| Fixed-point type (FXP) | X | X | ![]() |
![]() |
![]() |
![]() |
![]() |
![]() |
![]() |
![]() |
![]() |
![]() |
![]() |