Formatting data

• Data validation

Articles

• Best practices: Before submitting a data formatting request
• The difference between a file that can be formatted and a file that can't
• Data Formatting Tips & Tricks
• Converting Text Files (delimited or fixed width) to Excel
• Common GDPdU data formatting steps
• Data Formatting Guide: Looking up and Retrieving Data from Another File
• Data Formatting Guide: Excel Quick Reference
• Data Formatting Guide: Ungrouping and Checking Imbalance
• Data Formatting Guide - Tudor
• Data Formatting Guide: Ungrouping Files: ungroup and split
• Data Formatting Guide - Microsoft Great Plains (GP)
• Data Formatting Guide: The Basics
• Data Formatting Guide: Consolidating Duplicate Trial Balance Accounts
• General ledger data spans multiple worksheets
• Data Formatting Guide - Quickbooks Sub-Accounts
• Separating a Cell's Data
• Copying Account and Account Description Information
• Converting dates into the appropriate format
• Converting Negative Credit Values into Positives
• Converting Debit and Credit Columns to Numbers