Improve cryptic number formatting (##,#) with preview...
Current number formatting using ##.#, ? , semi colons and commas is too cryptic and has no preview and is just doesn't fit the Excel style. Instead, provide a dialog box similar to font selection with instant preview along with conditional formatting, number format separation, color. Also an option to select for positive, negative, zero and text.
@Jaroslav - yep, that's what I was referring to, but Chandran is asking to not use the number formatting symbols.
Jaroslav Svestka commented
But there is a preview, isn't there? See http://imageshack.com/a/img924/9801/P1tPws.png
@Chandran - got it. I'm removing the status, so other users can vote on the idea. And, I'm capturing what I had there, here for posterity.
One other thing I'll note - we have a little bit of what you're asking for (I think) in the Ribbon today. There are buttons there for currency ($), percentage (%), comma (,), increase/decrease decimals (+.00/-.00), and of course the "preset formats" in the drop down. But those definitely aren't specifically what you're suggesting.
Thanks for the idea,
=== from earlier status ===
Previewing number formats is already supported in current versions of Excel. To see the preview, make sure that you have a cell selected that has a number that you want to apply the number format to, and then use the Number formatting dialog. When you do that, you’ll see the value in the selected cell previewed (In the Number Format dialog, above the format string) with whatever number format you choose.
Hope that helps,
From Chandran: What I meant is not just the preview but complete elimination of the cryptic format from the user and providing dialogs, pull downs, check boxes, radio buttons etc similar to font selection dialog.