Excel Custom Formats (Table of Contents)

Summary: The fundamental building block to displaying your data is the feature known as custom formats. Here is the table of contents for Excel Custom Formats, Fifth Edition, the definitive guide to mastering the formatting power in Excel.

Excel Custom Formats (Table of Contents)

Excel Custom Formats, Fifth Edition, includes 85 information-packed pages that will help you discover and master the custom formatting capabilities of Excel. The following is the Table of Contents:

Introduction

  • A Word about Versions
  • Need More Tips?
  • Sharing this E-Book

Custom Formatting Basics

  • Understanding Custom Formatting
  • Understanding Number Formatting Codes
  • Understanding Date and Time Formatting Codes
  • Understanding Color and Conditional Formatting Codes
  • Adding a Custom Format to those Offered by Excel
  • Saving Custom Formats
  • Creating Two-Line Custom Formats

Numeric Formatting

  • Displaying Negative Percentages in Red
  • Turning a Cell Red when a Threshold is Exceeded
  • Altering the Displayed Format of Numbers to the Nearest 100
  • Formatting Currency
  • Getting Rid of Leading Zeros in a Number Format
  • Notation for Thousands and Millions
  • Entering Data as Thousands
  • Easily Dividing Values by 1000
  • Custom Formats for Scientific Notation
  • Handling Negative Numbers in a Complex Custom Format
  • Incrementing Numeric Portions of Serial Numbers
  • Stopping Fractions from Reducing
  • Numbers in Base 12
  • Moving Custom Formats to Number Formatting Categories

Date and Time Formatting

  • Unique Date Displays
  • Entering Dates without Separators
  • Can't Enter Years in a Cell
  • Dates with Periods
  • Macro for Month Name
  • Sorting Dates by Month
  • Entering Large Time Values
  • Displaying a Result as Minutes and Seconds
  • Formatting for Hundredths of Seconds
  • Dealing with Small Time Values
  • Using an Input Mask

Formatting Techniques and Ideas

  • Easy Value Hiding
  • Hiding Individual Cells
  • Hiding a Hyperlink on a Printout
  • Setting an Upper Threshold for a Cell
  • Using a Custom Format to Add Dashes
  • Partially Blocking Social Security Numbers
  • Superscripts in Custom Formats
  • Engineering Calculations
  • Changing the Percent Symbol
  • Inserting a Radical Symbol
  • Decimal Tab Alignment
  • AutoFilling Numbers with a Trailing Period
  • Adjusting Cell Margins for More White Space
  • Sorting Text as Numbers
  • Labeling X-Y Scatter Plots
To celebrate the release of the new, updated edition of Excel Custom Formats, for a limited time (through September 25, 2019) you can download your own copy of this valuable e-book for 30% off the regular price. Get your discount; place your order today!

Description CD Download
Excel Custom Formats Buy on CD
ISBN 978-1-61359-488-9 (85 pages)
$26.99 $18.89
Buy Download
ISBN 978-1-61359-487-2 (1.1 MB)
$19.99 $13.99

You can also order Excel Custom Formats by calling our order line: 307-200-0450.