Numeric formatting

Numeric formatting refers to how a number appears in the cell. In addition to choosing from an extensive list of predefined formats, you can create your own formats (see Figure 2-16). The procedure is thoroughly explained in the Help system.

famuli f>lh

OMSjtrv,

GEf*fBi Murexf

Accwilr^

^rKflcr rtm

CiEtof

IfffT^

i. isnhC

J UtJ* "JuJiJ

M^.ti" i*.'*>.w)-.sr '--njiJioj Jf ^.4= FH.mj;.[-(i,"<MX(;.{- ■■L"J;„tSJ MBO

llt'll-illl

Trunin-id

Epet fvMt&it. uflng m at trairiq *t * xirciq

Figure 2-16: Excel's numeric formatting options are very flexible.

Excel applies some numeric formatting automatically, based on the entry. For example, if you precede a number with a currency symbol (a dollar sign in the U.S.), Excel applies Currency number formatting. A new feature in Excel 2007 enables you to apply number formatting conditionally, using the conditional formatting feature.

0 0

Post a comment