Spreadsheets_storingdata

=Spreadsheets - Storing Data properly= include component="page" page="menu-Applications" editable="1" include component="page" page="menu-spreadsheets" editable="1"

TIPS: For numeric data to be calculated later, it's important that you
 * 1. USE PLAIN NUMBERS**
 * Store numbers WITHOUT units, seperators etc.**

ie. Don't type in something like $4,500,000 Type in 4500000 and use the spreadsheet's formatting tools (FORMAT- CELLS - NUMBERS) to make it LOOK like $4,500,000

Sometimes, your numeric data appears to give you ### Widen the Columns in order to see how it's been formatted. Often, you have to format away the decimel places to make the number appear properly
 * 2. WIDEN the COLUMNS**