2007: Number format <> Number format

G

GeoBrooks

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
 
S

Sheeloo

If you would look just above the Comma on the Number group you will find a
dropdown telling you the formatting applied to the cell(s).

You will also notice that when you click on the Comma the formatting applied
is 'Accounting' which is the same as
_(* #,##0.00_);_(* (#,##0.00);_(* "-"??_);_(@_)

Now when you click on the decimal button to reduce the number of decimals to
zero, formatting changes to 'Custom' (which is what you are doing) which is
the same as
_(* #,##0_);_(* (#,##0);_(* "-"??_);_(@_)

Now when you apply the format Number with zero decimals you are really
applying
#,##0_);(#,##0)

which is different from the one you get by clicking on Comma (as it should
be since Comma applies the 'Accounting' format)

btw thanks to your post I noticed the drop-down (for the first time) today...

Goes to show that you can work with it for years and still miss things which
are right in front of your eyes....

Have a nice day....

Q: Do I qualify as 'picky'?
or 'attentive' :)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top