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.
| A | Source | Text |
| B | Date | Date (eg dd-mmm-yyyy) |
| C | Month | Text |
| D | Source No. | Text |
| E | 2nd Source no. | Text |
| F | Note | Text |
| G | Foreign Currency | Number |
| H | Rate | Number |
| I | Converted | Number |
| J | Accounts | Text |
| K | Checking Accounts | Text |
| L | Amounts DR/CR | Number |
| M | Cumulative Amounts | Number |
| N | Bank Reconciliation marking | Text |
| O | Sales Invoice Status | Text |
| P | Debt Age | Number |
| Q | Debt Age Group | Text |
| R | Debt Term | Number |
| S | Debt Due date | Date |
| T | Item purchased/Sold | Text |
| U | Credit Purchase status | Text |
| V | Credit Age | Nmber |
| W | Credit age group | Text |
| X | Credit term | Number |
| Y | Credit due date | Date |
| Z | Original Order | Number |
No comments:
Post a Comment