The Proper Format

None of the above edits cares about the position of any particular character. They simply filter character entry one by one when the entered field is recorded. The rest of the global edits format data entry in various ways. This means that the position a particular character occupies in its field may be significant.

$ converts to dollars and cents format, supplying dollar sign and decimal point if not entered manually (does not round numbers)

ZIP zip code format; supplies "dash in 10-character code

SSNUM Social Security Number format; supplies dashes.

PHONE converts 7 digits to the form, nnn-nnnn; 10 digits to the form, (nnn) nnn-nnnn

Was this article helpful?

0 0

Post a comment