Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 410
  • Last Modified:

Excel 2003, 2007, 2010 - Custom Formatting Syntax

I don't see what difference it makes if I have a ampersand at the end of my custom format.  For instance:
#,##0.00_);[Red](#,##0.00);0.00;
works the same as
#,##0.00_);[Red](#,##0.00);0.00;@

is there something I'm not understanding about this?
0
brothertruffle880
Asked:
brothertruffle880
1 Solution
 
EirmanCommented:
Excel see a cell's format as having four Sections.....
Positive numbers ; Negative Numbers ; Zero Values ; Text values

So having the @ placeholder means that text in a cell is seen as text

Not having the 4th section defined make no difference to the number format of a cell.
It could make a difference to a cell's appearance if it vacillates between numbers and text.

For some info on text formats ....
http://www.ozgrid.com/Excel/CustomFormats.htm
0

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Tackle projects and never again get stuck behind a technical roadblock.
Join Now