Tuesday, June 28, 2011

* Columns format

Column Formatting

Certain columns need to be formatted with appropriate format to accommodate proper types of data. Usually, data can be a 'text' type, 'date' type or 'number' type. Columns to accommodate 'date' type must be formatted with 'date' formatting. Columns to accommodate 'number' type must be formatted with 'number' formatting. Columns to accommodate text 'type' must be formatted with 'text' formatting.

This book does not show you how to format a cell since the author expects that you already know how to perform this basic task.

ASourceText
BDateDate (eg dd-mmm-yyyy)
CMonthText
DSource No.Text
E2nd Source no.Text
FNoteText
GForeign CurrencyNumber
HRateNumber
IConvertedNumber
JAccountsText
KChecking AccountsText
LAmounts DR/CRNumber
MCumulative AmountsNumber
NBank Reconciliation markingText
OSales Invoice StatusText
PDebt AgeNumber
QDebt Age GroupText
RDebt TermNumber
SDebt Due dateDate
TItem purchased/SoldText
UCredit Purchase statusText
VCredit AgeNmber
WCredit age groupText
XCredit termNumber
YCredit due dateDate
ZOriginal OrderNumber


No comments:

Post a Comment