Custom Format Cells - Add ability to Format Like Sample
In the year 2019 there MUST be a better way to create custom cell formats in Excel.
Please add the ability to create a custom number format based on cell contents. The Sample shown could be used as the template source.
One beauty of ordering Excel to "format like sample" is it could compose the format of two parts:
1. The normal symbols for the basic format, like "#,###.00", which could then be edited directly for variations and simple fixes when the sample is misunderstood or less than wonderfully conceived.
2. An element that would be presented kind of like a picture would be, monolithic and not necessarily editable, though it'd be nice to be able to edit it.
The second element could capture most of the uniqueness of the formatting one figures is meant. Excel could store it however IT felt it best represented. No interpreting our human mishmash and attempts to force things it never really intended. Also, no limitations on Excel in presentation of what we enter. (An example is generating a format that includes text (perhaps text for the currency symbol) of a language that writes right to left, but trying to ********* the left, not the right. Excel currently will let you enter it where you want it and then puts it at the right regardless ('cause you're a fool, apparently).) But this idea here would allow Excel to see how, exactly, you intended the character to be presented and it could just do it instead of seeing it and trying to apply the rules of conventional use for it that it is aware of... subverting you... and not applying rules it is not aware of... leaving you out to hang if it would have been good to help you with them. None of that. It sees where you have it relative to the other elements and puts it there, no need to check you on it and correct you... it'd just do it.
(Seems like that'd be simpler for Excel and therfore desirable.)