Macabacus and Microsoft (for the most part) no longer support Internet Explorer 10 and prior versions. Please consider upgrading your browser.

- Preface
- Installation Instructions
- Activation & Licensing
- Initial Setup Guide
- Manage Settings
- General Usage Tips
- Update Notes

- Formatting
- Rows / Columns / Sheets
- Formulas & Data
- Financial Modeling
- Auditing
- Charting
- Super Find
- Publishing
- View & Interface
- File Operations
- Cell Comments
- Keyboard
- Undo / Redo
- Export to PowerPoint / Word
- Libraries

- Presentation Automation
- New Presentations
- Agendas (Tables of Contents)
- Import from Excel
- Link to Excel
- Linked Slides
- Presentation Proofing
- MasterShapes
- TurboShapes
- Styles
- Shapes & Text
- Colors
- Tombstones
- Slide Numbering
- Airplane Mode
- Libraries

A number format cycle includes one or more number formats. Simply repeat a cycle's shortcut keystroke to apply the next format in the cycle to selected cells. Macabacus comes pre-loaded with carefully selected number formats that we recommend for financial modeling because they work well for aligning numbers in commonly used finance.

The number formats in each cycle can be customized The number formats in each cycle can be customized in the `Excel > Format > Numbers`

section of the Settings dialog. Check the `Align numbers right`

box on the Numbers tab to automatically align numbers to the right of the cell when applying number formats using these cycles. Check the `Italicize percentages`

box on the Numbers tab to automatically italicize fonts when applying percentage number formats.

A single dollar sign ("$") in a number format instructs Excel to apply the currency symbol (e.g.,"€", "£") set in Windows. To ensure that currencies are formatted in USD, regardless of your Windows currency symbol setting, replace all occurrences of "$" with "[$$]" in your currency number formats.

If a number format cycle does not appear to be working, the workbook may contain too many number formats (an Excel limitation). Try removing unused number formats from the workbook.

If you receive an "Invalid number format" error when customizing number format cycles, the active workbook may contain too many number formats. In this scenario, open a new workbook and try again.

Example: 1,000; 1,000.0; 1000

Ctrl

Shift

1

Example: $345; $1,234.5; $15.75

Ctrl

Shift

4

Example: €500.0; ¥20,000; £14.5

Ctrl

Alt

Shift

4

Example: 49.9%; 150bps; L+350

Ctrl

Shift

5

Example: 8.9x; 1.25x

Ctrl

Shift

8

Example: 9/30/2016; 2016-09-30; Sep 30, 2016

Ctrl

Shift

2

Example: Yes/No; Y/N; On/Off; True/False

Ctrl

Shift

Y

Example: 1.23:1; 6/10

Alt

Shift

;

For optimal Increase/Decrease Decimals performance, ensure that your thousands and decimal separator (e.g., "," and ".") settings in Excel match your system separator settings.

*Increase* the number of decimal places shown for numeric values in selected cells. Repeat to continue increasing the number of decimal places shown.

Ctrl

,

Shift the decimal point to the *left* for all numeric inputs within the selected range of cells. This has the same effect as *dividing* by 10. Repeat to continue shifting the decimal point to the left. Note that this operation works on numeric inputs, only, and will not modify formulas.

Alt

Shift

,

*Decrease* the number of decimal places shown for numeric values in selected cells. Repeat to continue increasing the number of decimal places shown.

Ctrl

.

Shift the decimal point to the *right* for all numeric inputs within the selected range of cells. This has the same effect as *multiplying* by 10. Repeat to continue shifting the decimal point to the right. Note that this operation works on numeric inputs, only, and will not modify formulas.

Alt

Shift

.

This documentation refers to Macabacus version 8.9.3, and may differ from the PDF documentation

on your computer that installed with your version of Macabacus.