Ampler cycles the selected cells through your company’s standard currency formats in a keystroke, so numbers are formatted consistently across a model.
Quick answer: Select the cells and click Cycle currency format on the Ampler ribbon; click again to cycle to the next format.
How to use it
Select the cells, then cycle the format.
- Select the cells you wish to format.
- Click Cycle currency format (Ctrl+Shift+4), and click again to cycle to the next format.
The formats it cycles through are the ones defined under Settings → Cycles, so you can set them to your company standards.
Keyboard shortcut
Cycle currency format is Ctrl+Shift+4 by default; reassign it in the Ampler Settings → Shortcuts.
Why use it
A model that spans several currencies needs each formatted correctly and consistently. Ampler sets up your most-used currencies so they’re a keystroke away, cycling between them.
How consultants use it
Consistent number formatting is a basic quality signal in a model, and applying a house standard by hand is slow. Three habits apply:
- Your key currencies ready: the currencies you use most are set up to cycle
- Consistent across the model: each currency is formatted the same way throughout
- On the house standard: the formats come from the defined cycle
Cycling currency formats keeps a multi-currency model consistent.
Tips & best practices
- Select a range and cycle to the standard format.
- Set the formats to your house standard under Settings → Cycles.
- Keep formatting consistent across the whole model.
Availability
Included in Ampler for Excel and the Ampler Suite, on Windows desktop Excel.
Frequently asked questions
How do you format currencies in Excel quickly?
Select the cells and click Cycle currency format (Ctrl+Shift+4) on the Ampler ribbon to cycle through your set-up currencies.
What is the shortcut for currency format?
Ctrl+Shift+4 by default, reassignable in Ampler’s Settings.