A comprehensive guide to Number Formats in Excel

Contents1 Introduction2 Structure3 Character Codes3.1 Text Characters3.2 Number Characters3.3 Date Characters3.4 Time Characters4 Conditional Number Formats5 Using Colours6 Examples6.1 Display a signature strip6.2 Prefix a number with a single character6.3 Suffix a number with a text string6.4 Pad a number with n leading zero’s6.5 Align Positive and Negative numbers6.6 Understanding…

Continue reading

Excel – Pick the right tool for the job

Contents1 Tables:2 Formulas:3 Pivot Tables:4 Conclusion: Who does the caveman go to when he has a tooth ache? The dentist of course! Only back then, as you can imagine, the dentists’ tools were quite different to those used today. It has taken millennia to refine the tools we use in…

Continue reading