Formatting decimals shouldn't feel like a puzzle where the pieces keep changing shape. Yet here's a user who simply wants their spreadsheet to show $0.XX for values between -0.99 and 0.99, and whole numbers for everything else, no trailing decimals, no forced zeros above that threshold. The problem is that adding a zero before the # in a custom format string causes the system to display 0 for numbers higher than 0.99, which defeats the purpose. It's a small ask, but it exposes a much larger frustration: the gap between what people need from their data and what traditional formatting logic can deliver.
This user isn't looking for a workaround. They want a rule that says, "If the value is small, show me the cents; if it's large, show me the dollars, and let me adjust manually when I need to." That's a reasonable, human-centered request. But conventional spreadsheet tools treat number formatting as a one-size-fits-all mask applied to every cell in a range. You can't easily say, "Show precision for small numbers, simplicity for large ones." The result is that users end up fighting the tool instead of focusing on the insight. That tension is exactly where innovation becomes necessary.
What this tells us is that formatting should be dynamic, not static. It should respond to the data itself, not just to a fixed pattern you typed into a dialog box. Imagine a system where you define a threshold, say, absolute value less than 1, and the display automatically switches between decimal precision and whole numbers, while still letting you override it with a click. That's not a fantasy. It's a design choice that prioritizes clarity over rigidity. And it's the kind of feature that turns a frustrating formatting exercise into a seamless part of your workflow.
The takeaway is simple: when a user has to ask how to make their numbers behave logically, the tool has room to grow. We believe the answer isn't another custom format string. It's a smarter approach that understands context, small values deserve detail, large values deserve brevity, and you should always remain in control. That's the direction we're heading, and it's one that puts your actual work, not your formatting hacks, front and center.