Gates Is Antichrist
Well-known Member
- Joined
- Aug 15, 2002
- Messages
- 1,961
I like how General format uses the decimal place only when necessary. It only shows it when there are numbers to the right of the decimal place. If integer, it suppresses the decimal digits as well as the "dot." Can I achieve that in a mask?
For applications where vertical [right-]justification is not useful, I like seeing cents when they exist, and when they don't, just the integer (with commas ... or else I'd use General!). I think I like the mask
#,###,###,###.#############
because it only shows decimal places when needed. However it always shows the decimal point. Condemn me for being greedy or picayunish, but can I quash the little dot as well - just as General does?
****** side note start ***********
You can stop here ... but here's a bonus advanced question, in the vein of junk and bloat: Let's say I apply that format to every cell in a large workbook. Is that "bloaty?" In studying old Leo Hauser discussions and code it seemed that the issue was in the NUMBER of formats, not the number of times used. Are there any definitive conclusions regarding this? Note that product version probably affects the answer. I happen to be on XL03.
Moreover, I'm ignorant as to how Excel associates a "sheet-wide" characteristic vs. "row- or column-wise" vs. "cell by cell." Is it "cheap" if you select the entire sheet (with Control-A's), but significantly expensive when selecting the used range and then applying the format?
****** side note ***********
For applications where vertical [right-]justification is not useful, I like seeing cents when they exist, and when they don't, just the integer (with commas ... or else I'd use General!). I think I like the mask
#,###,###,###.#############
because it only shows decimal places when needed. However it always shows the decimal point. Condemn me for being greedy or picayunish, but can I quash the little dot as well - just as General does?
****** side note start ***********
You can stop here ... but here's a bonus advanced question, in the vein of junk and bloat: Let's say I apply that format to every cell in a large workbook. Is that "bloaty?" In studying old Leo Hauser discussions and code it seemed that the issue was in the NUMBER of formats, not the number of times used. Are there any definitive conclusions regarding this? Note that product version probably affects the answer. I happen to be on XL03.
Moreover, I'm ignorant as to how Excel associates a "sheet-wide" characteristic vs. "row- or column-wise" vs. "cell by cell." Is it "cheap" if you select the entire sheet (with Control-A's), but significantly expensive when selecting the used range and then applying the format?
****** side note ***********