📊 Spreadsheet Formatter
Excel & Google Sheets Format Generator
Configure your desired currency, locale, and negative number style to generate ready-to-paste Excel custom number format codes.
1. Configure Format Parameters
2. Generated Excel Format String
[$$-en-US] #,##0.00;-[$$-en-US] #,##0.00;"-"Live Spreadsheet Preview:
| Scenario | Raw Value | Formatted Cell Display |
|---|---|---|
| Positive Number | 12500.5 | $12,500.50 |
| Negative Number | -450.75 | -$450.75 |
| Zero Value | 0 | $0.00 |
💡 How to apply in Microsoft Excel & Google Sheets:
- Select your cells → Press Ctrl + 1 (or Cmd + 1 on macOS).
- In the Number tab, choose Custom at the bottom of the list.
- Paste this string into the Type: box and click OK.
📖 In-Depth Guide
Master custom format strings, accounting codes, and international decimal rules.
Read Excel Formatting Tutorial →🏛️ Official Documentation
Official reference for custom number formatting directly from Microsoft Support.
Microsoft Custom Number Formatting Guide →