Edit Code

Description

–

For date fields: mm-dd-yyyy or yyyy-mm-dd

For timestamp fields: mm-dd-yyyy-hh:mm:ss or

          yyyy-mm-dd-hh:mm:ss

/

For date fields: mm/dd/yyyy or yyyy/mm/dd

For timestamp fields: mm/dd/yyyy/hh:mm:ss or           yyyy/mm/dd/hh:mm:ss

#

yyyy Month dd for date fields

1

Commas, no sign, 0.0

2

Commas, no sign, blank

3

No commas, no sign, 0.00

4

No commas, no sign, blank

5

Explicit, CR/DR

6

Commas, '*' as suffix

7

Commas, c as prefix, '-'

8

Commas, 'c' as prefix, '-'

9

Edit word for date field, '-' as separator

A

Commas, CR, 0.00

B

Commas, CR, blank

C

No commas, CR, 0.00

D

No commas, CR, blank

J

Commas, '-', 0.00

K

Commas, '-', blank

L

No commas, '-', 0.00

M

, '-', blank

P

Edit word for phone number

R

No commas, no sign, 0.00

S

Edit word for U.S. social security number

T

Edit word for time fields

W

Edit word for long dates dd/mm/ccyy

Y

Edit word for date fields

Z

Zero suppression only