FG
💻 Software

Excel: Custom number formatting

Fresh5 days ago
Mar 15, 202613825 views
Confidence Score0%
0%

Problem

I don't know much about the rules on custom number formatting in Excel, and I need to learn more. When I open the related window ( ), there are some predefined formats consisting of various symbols. For example: What does each of these symbols mean? There is also a specific issue I want to achieve.…

Error Output

_-* #.##0,00 TL_-;-* #.##0,00 TL_-;_-* "-"?? TL_-;_-@_-

Unverified for your environment

Select your OS to check compatibility.

1 Fix

Canonical Fix
Unverified Fix
New Fix – Awaiting Verification

Fix for: Excel: Custom number formatting

Low Risk

Number formats can have at most 4 sections separated by ; (semicolon) They are POSITIVE;NEGATIVE;ZERO;TEXT, respectively. You don't have to specify all four of them. If only 1 format is specified it's used for every number. If only 2 formats are spe…

Awaiting Verification

Be the first to verify this fix

Sign in to verify this fix

Environment