Edit codes and date formats |
 |
By Carmen Nuland
01 Jun 2004 | Search400.com |
|
|
Helpful edit codes
|
|
No Sign |
CR
|
Right-
|
Float-
|
|
Comma, Zero
balance
|
1
|
A
|
J
|
N
|
|
Comma only
|
2
|
B
|
K
|
O
|
|
Zero balance only
|
3
|
C
|
L
|
P
|
|
None
|
4
|
D
|
M
|
Q
|
X – (obsolete; but it does retain leading zeros!)
Y – Slash insertion for date
Z – Zero suppresses leading zeros (no decimals, negatives)
Date formats
*MDY
|
mm/dd/yy |
*DMY
|
dd/mm/yy |
| *YMD
|
yy/mm/dd |
| *JUL |
yy/ddd |
| *ISO
|
yyyy-mm-dd
(24.00.00) |
| *USA |
mm/dd/yyyy
(12:00 AM) |
| *EUR |
dd.mm.yyyy (24.00.00) |
| *CYMD |
cyy/mm/dd |
| *LONGJUL |
yyyy/ddd |
| *HMS |
24:00:00 |
| *JIS |
24:00:00 |
*Y, *M, *D, *H, *MN *S, *MS (microsec)
Carmen Nuland is a systems analyst with Hal Leonard Corp.
|
|
|
|
