Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
In Excel 2007:
If one formats a range using the Ribbon: Number group, Number (from the drop down box), Comma, click the decrease decimal button twice, the cell(s) are formatted with padding on the right. Using the Format command to view the applied format, one finds that a custom format has been applied. If one instead uses the Cells group, Format command (or right click, Format cells...) and selects Number, comma separator, zero decimals, the cell(s) are formatted without padding. In this case, no custom format has been applied. Yeah, I know. Picky, picky. It just pays to be consistent. And attentive. G |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Conditional number format in Excel 2007 | Excel Discussion (Misc queries) | |||
How do you change the default number format in Excel 2007? | Excel Discussion (Misc queries) | |||
Excell 2007 - Number format corruption | Excel Discussion (Misc queries) | |||
Currency format for Excel 2007 not displaying actual number | Excel Discussion (Misc queries) | |||
Excel 2007 Pivot table cells number format changes w/out user inpu | Excel Discussion (Misc queries) |