Numbers, dates and text formats

Definition and example

Numbers, dates and text formats means Spreadsheets store values separately from display formats. A date stored as text may not sort correctly; currency formatting changes appearance, not numeric value. Practice: Enter dates and amounts in separate columns and format them as date and currency. Try this in the application, check the result, then save your work in your IT Practice folder. If an option is unavailable on your device, use the equivalent Microsoft or Google app and record what you observed For example, What does applying currency format do? Do this in the named application, inspect the result, and save a clearly named copy. This makes the skill repeatable in school, work and everyday online tasks.