Formatting tsis zoo, Ntev, thiab Numbers tshwj xeeb hauv Excel

01 ntawm 04

Formatting Cov Sij Hawm nyob hauv Excel Txheej txheem cej luam

Cov ntaub ntawv ntawm cov zauv tshwj xeeb muaj nyob rau hauv cov nplooj ntawv txuas mus ntxiv no:

Nplooj 1: Cov nab npawb tsis zoo (hauv qab);
Nplooj 2: Cov zauv suav cov zauv raws feem (fractions);
Nplooj 3: Cov naj npawb tshwj xeeb - tus zip code thiab tus xov tooj formatting;
Nplooj 4: Formatting ntev - xws li credit card numbers - raws li cov ntawv nyeem.

Tooj zauv hauv Excel yog siv los hloov cov tsos ntawm tus nab npawb los yog tus nqi hauv ib lub xov tooj ntawm tes hauv daim ntawv ua haujlwm.

Tooj formatting txuas nrog rau ntawm tes thiab tsis rau tus nqi hauv xov tooj ntawm tes. Hauv lwm cov ntsiab lus, hom ntawv formatting tsis hloov tus xov tooj ntawm tus xovtooj, tab sis tsuas yog txoj kev nws tshwm.

Piv txwv, siv cov txiaj, feem pua, los sis cov zauv rau cov ntaub ntawv tsuas yog pom hauv lub xov tooj ntawm tus xov tooj nyob qhov twg. Txhawm rau ntawm lub xov tooj ntawm tes yuav qhia qhov dawb, unformatted tus naj npawb hauv cov qauv mis saum toj ntawm daim ntawv ua haujlwm.

Tus Txheej Txheem Li Cas

Lub hom phiaj rau lub hlwb uas muaj tag nrho cov ntaub ntawv yog Hom Kev Xam Phaj. Cov style no tsis muaj cov hom thiab, vim yog, cov zauv uas tsis muaj cov cim cim los yog nyiaj zauv thiab cov zauv ntawm cov zauv - cov zauv uas muaj feem xyuam nrog cov zauv feem ntau - tsis tas rau qee cov zauv.

Tooj formatting yuav siv tau rau ib tus xov tooj ntawm tes, tag nrho kab los yog kab, xaiv ntau ntawm cov hlwb, los yog tag nrho daim ntawv .

Teeb meem tsis sib haum xeeb

Yog lub neej ua ntej, cov zauv negative pom tau tias yog siv qhov tsis zoo lossis kos npe (-) mus rau sab laug ntawm tus xov tooj. Excel muaj ob peb lwm txoj kev xaiv rau kev tso saib cov zauv tsis zoo nyob rau hauv Hom Tshuaj Kab Ntawv Sib Tham . Cov no suav nrog:

• liab ntawv
• puag ncig brackets
• puag ncig brackets thiab liab ntawv

Kev pom cov zauv tsis zoo hauv cov xim liab yuav ua kom yooj yim rau lawv - tshwj xeeb tshaj yog tias lawv yog cov qauv ntawm cov qauv uas tej zaum yuav nyuaj rau taug qab hauv daim ntawv ua haujlwm loj.

Cov khoom siv feem ntau yog siv los ua cov zauv tsawg uas yooj yim los txheeb xyuas cov ntaub ntawv uas yuav muab luam tawm hauv cov xim dub thiab dawb.

Hloov Cov Hloov Tsis Zoo Tus Naj Npawb Qhia Hauv Hom Ntawv Xov Tooj Dialog Box

1. Tshawb cov ntaub ntawv teeb tsa
2. Nias rau ntawm lub tsev tab ntawm txoj hlua
3. Nias rau ntawm lub thawv dialog box - lub me downward pointing xub hauv qab ntawm txoj cai hauv qab ntawm pawg Pab Pawg Npe ntawm qhov ribbon qhib lub Hom Tshuaj Qhov Sib Thooj
4. Nias rau Naj npawb hauv qab seem ntawm lub thawv ntawv sib tham
5. Xaiv ib qho kev xaiv rau cov zauv negative - liab, nkhaus, lossis liab thiab nkhaus
6. Nias lawv xav kom kaw lub thawv tawm thiab xa rov tuaj rau ntawm daim ntawv ua haujlwm
7. Tsis zoo qhov tseem ceeb ntawm cov ntaub ntawv xaiv yuav tsum tam sim no muaj formatted nrog xaiv xaiv

02 ntawm 04

Formatting Cov zauv ua cov zauv nyob hauv Excel

Tso Teeb Meem Cov Naj Npawb raws li Feem Zauv

Siv cov Fraction format los tso saib cov zauv los ua cov zauv feem ntau, tsis yog decimals. Raws li teev nyob rau hauv Cov Lus Qhia Tshuam nyob hauv daim duab saum toj no, cov kev xaiv muaj rau cov zauv feem muaj xws li:

• muab cov zauv los ua ib qho, ob, los yog peb tug zauv feem ntawm tus lej feem ntau ntawm tus lej;
• nthuav tawm cov zauv (decimals) raws li feem ntau siv feem (fractions) - xws li ib nrab thiab ib nrab.

Hom Ntawv Thawj, Cov Ntaub Ntawv Ob

Feem ntau, nws yog qhov zoo tshaj plaws los thov cov ntawv me me rau cov qe ntshav ua ntej nkag mus rau cov ntaub ntawv kom tsis txhob muaj kev tshwm sim.

Piv txwv, yog cov zauv ntawm cov zauv hauv nruab nrab ntawm ib thiab 12 - xws li 1/2 los sis 12/64 - muab sau rau hauv hlwb nrog Hom Lus, cov zauv yuav raug hloov mus rau cov hnub xws li:

• 1/2 yuav muab xa rov qab ua 2-Jan
• 12/64 yuav raug xa rov qab thaum Jan-64 (Lub Ib Hlis, 1964)

Zoo li, cov zauv feem ntau nrog cov zauv tshaj 12 yuav raug muab xa mus rau hauv cov ntawv nyeem, thiab yuav ua rau muaj teeb meem yog siv cov lus teb.

Hom Naj Nres raws li Feem Zauv Hauv Hom Tshuaj Lub Thawv Ntaus Xov Tooj

1. Ua kom pom cov qe ntshav kom raug muab ua cov zauv
2. Nias rau ntawm lub tsev tab ntawm txoj hlua
3. Nias rau ntawm lub thawv dialog box - lub me downward pointing xub hauv qab ntawm txoj cai hauv qab ntawm pawg Pab Pawg Npe ntawm qhov ribbon qhib lub Hom Tshuaj Qhov Sib Thooj
4. Nias rau ntawm Fraction nyob rau hauv seem hauv seem ntawm qhov kev cai sib tham kom pom cov npe ntawm cov zauv muaj nyob ntawm sab xis sab ntawm cov lus sib tham
5. Xaiv ib hom ntawv rau cov zauv suav zauv raws li cov zauv ntawm daim ntawv
6. Nias lawv xav kom kaw lub thawv tawm thiab xa rov tuaj rau ntawm daim ntawv ua haujlwm
7. Cov zauv naj npawb uas tau muab ntaus rau hauv kab ntau yam yuav tsum tau muab tso tawm kom pom cov zauv

03 ntawm 04

Teeb Meem Tshwj Xeeb hauv Excel

Tus Naj Npawb thiab Zauv Naj Npawb

Yog tias koj siv Excel khaws cov zauv ID - xws li cov zip codes los yog xov tooj - koj yuav pom tus naj npawb raug hloov los yog tso tawm nrog cov kev xav tau.

Yog vim li cas, txhua lub hlwb nyob rau hauv ib daim ntawv Excel sau siv hom General , thiab tus yam ntxwv ntawm hom ntawv no muaj xws li:

• ua zeros hauv cov zauv raug tshem tawm,
• cov lej uas muaj ntau tshaj 11 tus lej muab hloov dua siab tshiab rau kev tshawb fawb (los yog exponential).

Ib yam li ntawd, Cov Zauv Naj Npawb tsuas yog siv rau cov zauv ntawm 15 tug lej ntawm qhov ntev. Cov nab npawb tshaj li qhov txwv no yog sib npaug mus rau zeroos

Yuav kom tsis txhob muaj teeb meem nrog cov zauv tshwj xeeb, yuav tsum siv ob qho kev xaiv nyob ntawm seb hom nab npawb twg yog nyob rau hauv daim ntawv ua haujlwm:

• qhov tshwj xeeb hom nyob rau hauv Hom Tshuaj Kab Xev Xov Tooj (saib hauv qab);
• formatting numbers raws li cov ntawv (nplooj ntawv tom ntej).

Yuav kom paub meej tias cov naj npawb tshwj xeeb tau muab cov lus qhia ntxaws ntxoo tawm thaum nkag mus, tsim hom xov tooj ntawm tes los yog hlwb siv ib hom ntawm ob sab hauv qab ua ntej nkag mus hauv tus naj npawb.

Tshwj Xeeb Hom Ntawv

Qhov tshwj xeeb qeb nyob rau hauv Hom Tshuaj Kab Ntawv Sib Tham Xov Tooj siv cov ntawv tshwj xeeb rau cov lej xws li:

• xov tooj - muab tus lej thib peb ntawm tus nab npawb ntawm 10 tus lej thiab cais cov xya leej ntxiv rau hauv ob pawg sib cais. Piv txwv: (800) 555-1212
• Cov lej Xaus Saus - cais cuaj tug lej rau ib pawg ntawm peb, ob, thiab plaub sib cais los ntawm hyphens. Piv txwv: 555-00-9999

• Zip codes - khaws cov kev ua zauv nyob rau hauv cov zauv - uas tau muab tshem tawm nrog cov naj npawb tawm tswv yim. Piv txwv li: 00987

• zauv teb chaws + 4 : cais cuaj tug lej rau hauv ib pawg ntawm tsib tug lej thiab plaub sib cais los ntawm ib lub thawv. Kuj tseem khaws cov ua zeros. Piv txwv: 00987-5555

Locale Sensitive

Cov ntawv teev npe hauv qab no muaj kev xaiv los ua cov qauv tshwj xeeb uas tsim nyog rau lub teb chaws. Piv txwv, yog hais tias Lub Zos hloov chaw rau Lus As Kiv (Canada) cov kev xaiv muaj yog Xov Tooj thiab Social Security Number - uas feem ntau siv tshwj xeeb rau lub teb chaws.

Siv Special Formatting rau cov zauv nyob rau hauv Hom Ntawv Cov Kws Sib Cav Dialog Box

1. Ua kom pom cov qe ntshav kom raug muab ua cov zauv
2. Nias rau ntawm lub tsev tab ntawm txoj hlua
3. Nias rau ntawm lub thawv dialog box - lub me downward pointing xub hauv qab ntawm txoj cai hauv qab ntawm pawg Pab Pawg Npe ntawm qhov ribbon qhib lub Hom Tshuaj Qhov Sib Thooj
4. Nias ntawm Tshwj Xeeb hauv seem hauv seem ntawm qhov kev cai sib tham kom pom cov npe ntawm cov ntawv tshwj xeeb muaj nyob rau ntawm sab xis ntawm lub thawv sab nraud
5. Yog tias tsim nyog, nyem rau ntawm qhov chaw xaiv qhov chaw hloov chaw
6. Xaiv ib qho ntawm hom kev xaiv rau kev tso cov naj npawb tshwj xeeb los ntawm daim ntawv teev npe
7. Nias lawv xav kom kaw lub thawv tawm thiab xa rov tuaj rau ntawm daim ntawv ua haujlwm
8. Cov nab npawb uas tsim nyog rau hauv ntau hom ntawv yuav tsum tau muab tso tawm kom pom nrog rau tus qauv tshwj xeeb

04 ntawm 04

Formatting Cov Npe raws li Ntawv hauv Excel

Tus Naj Npawb thiab Zauv Naj Npawb

Yuav kom paub meej tias cov lej ntev - xws li 16 daim credit card thiab cov npav nyiaj rau tus nab npawb ntawv - yog muab tso tawm kom pom thaum nkag mus, tsim hom xov tooj ntawm tes los yog hlwb siv cov ntawv nyeem - zoo dua ua ntej nkag mus rau cov ntaub ntawv.

Los ntawm lub neej ua ke, txhua lub hlwb nyob rau hauv ib qho Excel sau ntawv siv Hom Lus, thiab ib qho ntawm cov yeeb yam ntawm hom ntawv no yog cov zauv uas muaj ntau tshaj 11 tus lej muab hloov rau kev scientific (los yog exponential) cim tseg - raws li qhia hauv cell A2 hauv daim duab saum toj no.

Ib yam li ntawd, Cov Zauv Naj Npawb tsuas yog siv rau cov zauv ntawm 15 tug lej ntawm qhov ntev. Cov nab npawb tshaj li qhov txwv no yog sib npaug mus rau zeroos.

Hauv Cell A3 saum toj no, tus naj npawb 1234567891234567 yuav hloov mus rau 123456789123450 thaum lub xov tooj ntawm tes muab rau cov zauv hom ntawv.

Siv Cov Ntawv Teev Tseg hauv Cov Qauv thiab Cov Haujlwm

Teebmeem, thaum siv hom ntawv sau - A4 saum toj no - tib lub xov tooj qhia kom raug, thiab, txij li lub cim txwv ib ntawm tes rau ntawm hom ntawv nyeem yog 1.024, nws yog ntshe tsuas yog irrational tooj xws li Pi (Π) thiab Phi (Φ) uas tsis tuaj yeem pom tshwm sim hauv lawv txoj kev paub.

Ntxiv rau kev ua kom zoo ib yam li qhov tau sau tseg, cov zauv uas tau muab los siv ua cov ntawv tseem siv tau hauv cov qauv siv cov kev ua lej yooj yim - xws li kev ntxiv thiab rho tawm raws li qhia hauv cell A8 saum toj no.

Lawv ua tsis tau, txawm li cas los xij, yuav siv nws hauv cov lus teb nrog qee cov ntawv Excel ua haujlwm - xws li SUM thiab AVERAGE , raws li lub hlwb uas muaj cov ntaub ntawv raug muab khoob khoob thiab rov qab:

• ib qho ntawm xoom rau SUM - cell A9
• qhov yuam kev nqi # DIV / 0! rau AVERAGE - cell A10

Cov Kauj Ruam Los Teev Npe Tus Xov Tooj Rau Cov Ntawv

Xws li nrog lwm tus tawm tswv yim, nws yog ib qho tseem ceeb kom muab tus xov tooj ntawm tes rau cov ntaub ntawv ua ntej nkag mus rau tus xov tooj - yog tias nws, nws yuav raug cuam tshuam los ntawm cov xovtooj tam sim no.

1. Nias ntawm lub xov tooj ntawm tes los sis xaiv ib qho ntawm cov hlwb uas koj xav hloov ua hom ntawv
2. Nias rau ntawm lub tsev tab ntawm txoj hlua
3. Nias ntawm qhov xub hauv qab ntawm lub Npe Hom Lub Npe - qhia txog General los ntawm lub neej - qhib lub tshuab raj tawm ntawm hom ntawv xaiv
4. Tshem mus rau hauv qab ntawm cov ntawv qhia zaub mov thiab nias rau ntawm Cov Ntawv Kev Xaiv - tsis muaj cov kev xaiv ntxiv rau cov ntawv nyeem

Cov ntawv nyeem rau sab laug, Tooj ntawm sab xis

Ib qho kev pom tseeb los pab koj txiav txim siab lub xovtooj ntawm homphiaj yog los saib cov lus sib dhos.

Los ntawm kev ua neej nyob hauv Excel, cov ntaub ntawv tawm mus raws li sab laug rau hauv xov tooj ntawm tes thiab tus lej ntawm sab xis. Yog hais tias lub sijhawm ua haujlwm tsis zoo rau cov kab ntawv raws li cov ntawv sau tsis tau hloov, cov lej nkag mus rau hauv qhov ntau yam yuav tsum tau muab tso tawm rau sab laug sab ntawm lub hlwb raws li qhia hauv cell C5 hauv daim duab saum toj no.

Tsis tas li ntawd, raws li qhia hauv hlwb A4 rau A7, cov lej tawm hauv cov ntawv nyeem kuj tseem tuaj yeem pom daim duab me me ntawm daim duab peb sab rau sab laug ntawm sab laug ntawm lub xovtooj ntawm qhia tias cov ntaub ntawv yuav raug muab kho tsis raug.