Tag Archives: Data

Make phone numbers easier to read AND more useful to Excel

Put gaps or hyphens into telephone numbers, otherwise Excel thinks they are ordinary numbers, and removes the first zero. Gaps also make it easier for people to read the number. (Gaps between words were introduced by Irish scribes in the … Continue reading

Posted in Uncategorized | Tagged | Leave a comment

Don’t be sloppy when entering information

Well-structured information is the key to making the most of Excel. Each different data type should appear in its own column. Generally, it’s best to think of each row as a record (client names, sales records, inventory items, etc), with … Continue reading

Posted in Uncategorized | Tagged , | Leave a comment

Date formats – don’t waste valuable information!

Don’t enter dates with full stops (eg 10.11.13) because Excel doesn’t store them as dates, meaning a lot of useful information is unavailable. Instead, use a slash (eg 10/11/13) or hyphen (10-11-13) when you enter dates. Excel then stores them … Continue reading

Posted in Uncategorized | Tagged , , | Leave a comment