Ukufometha i-Negative, Ede, kunye neNombolo ekhethekileyo kwi-Excel

01 ngo 04

Ukufometha amanani kwi-Excel

Ulwazi malunga neefomathi ezithile zeefom zingatholakala kumaphepha alandelayo:

Ikhasi 1: Amanani amaninzi (ngezantsi);
Page 2: Bonisa iinombolo zokugqibela njengamaqhezu;
Ikhasi 3: Amanani akhethekileyo - iikhowudi ze-zip kunye nokufometha kwenombolo yefowuni;
Ikhasi 4: Ukufomatha amanani amade - njengamanani ekhadi lesikweletu - njengombhalo.

Ukufometha kwamanani kwi-Excel kusetyenziswa ukutshintsha ukubukeka kwenani okanye inani kwieseli kwiphepha lokusebenzela.

Ukufometha kwenani kuqhotyoshelwe kwiseli kwaye kungabi nakwixabiso kwiseli. Ngamanye amagama, ukufometha kwamanani alitshintshi inombolo ekhoyo kwiseli, kodwa nje ngendlela ebonakala ngayo.

Umzekelo, ukusebenzisa i-currency, ipesenti okanye ukufometha kwamanani kwi-data kubonakala kuphela kwiseli apho inombolo. Ukuqakraza kweso sisele kuya kubonisa inombolo ecacileyo, engaqinisekanga kwifom yefomula ngaphezu kwephepha lokusebenzela.

Jikelele

Ifomati engapheliyo yamaseli aqulethe yonke idatha yindlela eqhelekileyo. Le ndlela ayinayo ifomathi ethile kwaye, ngokuzenzakalelayo, ibonisa iinombolo ezingenazo iimpawu zeedola okanye ama-commas kunye namanani adibeneyo - amanani aqukethe icandelo elincinci - alinganiselwe kwinani elithile leendawo zokugqibela.

Ukufometha kwamanani kungasetyenziswa kwiseli enye, iikholomu okanye imiqolo, uluhlu lweetyeli, okanye lonke iphepha lokusebenzela .

Ukufometha kweNombolo engebiyo

Ngokungagqibekanga, iinombolo ezingekhoyo zichongwa ngokusebenzisa uphawu olungenanto okanye idatha (-) ngakwesobunxele benani. I-Excel inezinye iindlela ezinokukhethwa kwefomathi zokubonisa iinombolo ezingekho phantsi kwibhokisi yencoko yencoko yefomathi . Ezi ziquka:

• umbhalo obomvu
• mabakaki ajikelezayo
• iibhonki ezijikelezayo kunye nombhalo obomvu

Ukubonisa amanani amaninzi obomvu kunokukwenza kube lula ukuwafumana - ingakumbi ukuba ngaba yimiphumo yefomula ezinokuba nzima ukuzilandelela kwiphepha elibanzi lokusebenzela.

Iibhonkxa zivame ukusetyenziswa ukwenzela ukuba iinombolo ezimbi zilula ukufumana iinkcukacha eziza kuprintwa kumnyama nomhlophe.

Ukutshintsha i-Negative Number Formatting kwifayile yeefayile zeeNdiya zeeNdiya

1. Khankanya idatha ukuba ifomathiwe
2. Cofa kwiThebhu yasekhaya yerbhoni
3. Cofa kwibhokisi yebhokisi yencoko yebhokisi yencoko - encinci inqakrazo yokukhomba engezantsi kwekhoneni lekhonkco leqela kwi-Ribbon ukuvula ibhokisi yencoko yencoko yeefayile
4. Cofa kwiNombolo phantsi kweCandelo leCandelo lebhokisi yencoko
5. Khetha ukhetho lokubonisa amanani amaninzi - obomvu, amabakaki, okanye obomvu kunye neebakaki
6. Cofa OK ukuvala ibhokisi yencoko kwaye ubuyele kwiphepha lokusebenzela
7. Ixabiso elincinci kwi-data ekhethiweyo kufuneka ngoku ifomathiwe ngeendlela ezikhethiweyo

02 we 04

Ukufometha amanani njengamaqhezu kwi-Excel

Bonisa iNombolo e-Decimal njengeziqendu

Sebenzisa ifomathi yeFraction ukuze ubonise iinombolo njengamaqhezu okwenene, kunokuba ahlasele. Njengoko kubhalwe phantsi kwekholam yokuchazwa kumfanekiso ongentla, iinketho ezifumanekayo zeengxenyana zibandakanya:

• ukubonakalisa i-decimals njengenye, iimbini, okanye amaqhezu amanani amathathu kwingxenye yesininzi yenani;
• ukubonakalisa ama-decimals njengamaqhezu esetyenziswa rhoqo - njengesiqingatha esinye nesinye.

Ifomathi yokuqala, iDatha yeSibini

Ngokuqhelekileyo, kukulungele ukusebenzisa ifomati yefestile kwiiseli ngaphambi kokungena kwedatha ukuphepha iziphumo ezingalindelekanga.

Umzekelo, ukuba amaqhekeza aneenombolo phakathi kwe-12 kunye ne-12 -64 - angena kwiiseli ngefomathi jikelele , amanani aya kutshintshwa ibe yimini efana nale:

• I-1/2 iya kubuyiselwa ngo-2-Jan
• 12/64 iya kubuyiselwa ngoJan-64 (ngoJanuwari, 1964)

Kwakhona, iinqhezu ezinamaxabiso angaphezu kwe-12 ziya guqulwa zibe ngumbhalo, kwaye zingabangela iingxaki ukuba zisetyenziswe kwizibalo.

Ukufometha iinombolo njengeziqendu kwifayile yeefayile zeealog box

1. Gqamisa iiseli ukuba zifomathiwe njengeziqhezu
2. Cofa kwiThebhu yasekhaya yerbhoni
3. Cofa kwibhokisi yebhokisi yencoko yebhokisi yencoko - encinci inqakrazo yokukhomba engezantsi kwekhoneni lekhonkco leqela kwi-Ribbon ukuvula ibhokisi yencoko yencoko yeefayile
4. Cofa kwiFraction phantsi kweCandelo leCandelo lebhokisi yencoko yababini ukubonisa uludwe lweefom zefayile ezikhoyo kwicala lebhokisi yencoko yababini.
5. Khetha ifomathi yokubonisa iinombolo zokugqibela njengeziqhezu eziluhlu
6. Cofa OK ukuvala ibhokisi yencoko kwaye ubuyele kwiphepha lokusebenzela
7. Amanqaku afanelekileyo angeniswe kwibanga elifomathiweyo kufuneka iboniswe njengeziqendu

03 we 04

Ukufometha iinombolo ezikhethekileyo kwi-Excel

Jikelele kunye neNombolo yoLungiselo lweeNombolo

Ukuba usebenzisa i-Excel ukugcina iinombolo zokuchonga - njengeefowuni zeefowuni okanye iinombolo zefowuni - ungayifumana inombolo ifatshintshiwe okanye iboniswe ngeziphumo ezingalindelekanga.

Ngokungagqibekanga, zonke iiseli kwiphepha lokusebenzela lase Excel zisebenzisa iFomathi jikelele , kwaye iimpawu zale fom zibandakanya:

• i-zeros ezikhokelela kumanani zisuswa,
• amanani anamaxabiso angaphezu kwe-11 aya guqulwa kwi-notation yesayense (okanye ibonakaliso).

Ngokufanayo, ifomathi yeenombolo zikhawulelwe ukubonisa inani leenombolo ezili-15 ubude. Naliphi na idijithi ngaphaya komda wokuba uhlawulelwe kwii-zeros

Ukuze ugweme iingxaki ngamanani akhethekileyo, ukhetho oluninzi lunokusetyenziswa kuxhomekeke kukuphi uhlobo lwenani eligcinwe kwiphepha lokusebenzela:

• isigaba esikhethekileyo kwifom kwibhokisi yencoko yebhokisi yefayile (jonga ngezantsi);
• ukufomatha amanani njengombhalo (iphepha elilandelayo).

Ukuqinisekisa ukuba amanani akhethekileyo aboniswa ngokuchanekileyo xa efakwe, fomathile iseli okanye iiseli usebenzisa enye yefomathi ezimbini ngaphantsi kokuba ungene kwinombolo.

I fomathi ekhethekileyo

Udidi olukhethekileyo kwibhokisi yebhokisi yencoko yefomathi lisebenza ngokuzenzekelayo ukufomathiza kumanani anjengale:

• iinombolo zefowuni - zifaka iidijithi zokuqala ezintathu zeenombolo ezili-10 kwiibhareneses kwaye zahlula amadijithi asixhenxe aseleyo kumacandelo amabini ahlukileyo. Umzekelo: (800) 555-1212
• Izinombolo zoKhuseleko loLuntu - ukwahlula amanani amanani alithoba ukuya kumaqela a mathathu, amabini, kwaye amane ahlukaniswe ngabangqina. Umzekelo: 555-00-9999

• iikhowudi ze-zip - igcina ii-zeros ezikhokelayo kumanani - ezisuswa kunye namafomathi amanani rhoqo. Umzekelo: 00987

• i-zip code + 4 : ihlukanisa amanani eenombolo ezi-9 kumaqela eenombolo ezintlanu kunye nezine ezahlukileyo. Kwakhona igcina nayiphi na i-zeros ehamba phambili. Umzekelo: 00987-5555

Locale Sensitive

Uhlu lokuhlahla phantsi kwe- Locale lunikeza iinketho zokwenza ifomathi ezikhethekileyo ezifanelekileyo kumazwe athile. Umzekelo, ukuba i-Locale ishintshelwe kwisiNgesi (Canada) ezikhethiweyo ezikhoyo ziNombolo yeFowuni kunye nenombolo yomshuwalense wezenhlalakahle - eziqhelekileyo zisebenzisa amanani akhethekileyo kweli lizwe.

Ukusebenzisa ukuFometha okuKhethekileyo kwiNombolo kwiBhokisi yoLwazi lweeNethwekhi zeefayile

1. Gqamisa iiseli ukuba zifomathiwe njengeziqhezu
2. Cofa kwiThebhu yasekhaya yerbhoni
3. Cofa kwibhokisi yebhokisi yencoko yebhokisi yencoko - encinci inqakrazo yokukhomba engezantsi kwekhoneni lekhonkco leqela kwi-Ribbon ukuvula ibhokisi yencoko yencoko yeefayile
4. Cofa kwiCandelo elikhethekileyo phantsi kweCandelo leCandelo lebhokisi yencoko yokubonisa uludwe lweefom ekhethekileyo ezikhoyo kwicala lebhokisi yencoko
5. Ukuba kuyimfuneko, nqakraza kwi- Locale yokukhetha ukutshintsha indawo
6. Khetha enye yezakhelo zefomathi zokubonisa amanani athile avela kuhlu
7. Cofa OK ukuvala ibhokisi yencoko kwaye ubuyele kwiphepha lokusebenzela
8. Amanani afanelekileyo angeniswe kwifom efomathiweyo kufuneka iboniswe njengefomathi ekhethiweyo

04 we 04

Ukufometha amanani njengombhalo kwi-Excel

Jikelele kunye neNombolo yoLungiselo lweeNombolo

Ukuqinisekisa ukuba amanani amade - afana nekhadi lekhadi lesikratshi ezili-16 kunye namanani ekhadi ebhanki - aboniswa ngokufanelekileyo xa efakwe, fomathi iseli okanye iiseli esebenzisa ifomathi yefomathi - ngokufanelekileyo ngaphambi kokungena kwedatha.

Ngokungagqibekanga, zonke iiseli kwiphepha lokusebenzela lase Excel zisebenzisa iFomathi jikelele , kwaye enye yeempawu zolu fomathi kukuba amanani anamaxabiso angaphezu kwe-11 aya guqulwa kwi-notation yesayense (okanye ibonakaliso) -kuboniswa kwiseli A2 kumfanekiso ongentla.

Ngokufanayo, ifomathi yeenombolo zikhawulelwe ukubonisa inani leenombolo ezili-15 ubude. Naliphi na idijithi ngaphaya komda wokuba uhlawulelwe kwii-zeros.

Kwi-cell A3 ngasentla, inombolo 1234567891234567 ishintshelwe ku-123456789123450 xa iseli isetyenziselwa ukufometha kwenombolo.

Ukusebenzisa idatha yombhalo kwiifomula kunye nemisebenzi

Ngakolunye uhlangothi, xa ifomathi yokufomatha isetyenzisiweyo - ifowuni ye-A4 ngasentla - inombolo efanayo ibonisa ngokuchanekileyo, kwaye, ekubeni umda womlinganiso ngeselfom yesakhiwo sombhalo ngu-1,024, mhlawumbi ngamanani angenangqiqo njengoPi (Π) noFi (Φ) ezingenakuboniswa ngokupheleleyo.

Ukongeza kokugcina inombolo efana nendlela eyafakwa ngayo, amanani afomathiweyo njengombhalo angasetyenziselwa amafomula esebenzayo ngokusetyenziswa kweemathematika ezisisiseko - njengokungeza nokukhupha njengoko kuboniswe kwiseli A8 ngasentla.

Akunako, kodwa, angasetyenziselwa ngokubala kunye nemisebenzi ye-Excel - njenge-SUM ne- ALLVERAGE , njengoko iiseli eziqulethe idatha ziphathwa njengento engenanto kwaye zibuyela:

• isiphumo sero kwi-SUM - iseli ye-A9
• ixabiso lephutha # DIV / 0! ISIGABA - iseli A10

Amanyathelo okufometha iSeli kwiTekisi

Njengayezinye iifom, kubalulekile ukufomatha iseli kwidata yombhalo ngaphambi kokuba ungene kwinombolo - ngaphandle koko, iya kuchatshazelwa ngokufometha kweseli.

1. Cofa kwiseli okanye ukhethe uluhlu lweeseli ofuna ukuguqulela kwifomathi yombhalo
2. Cofa kwiThebhu yasekhaya yerbhoni
3. Cofa kwisalathiso esingaphantsi kwebhodi yefomathi yeenombolo - ukubonisa jikelele ngokuzenzekelayo - ukuvula imenyu yehla yokukhetha ifomathi
4. Skrolela ngasezantsi kwimenyu kwaye uqhosha kwi- Text option - ayikho enye inketho yokwenza ifomathi

Umbhalo ukuya kwi-Left, Numeri ngakwesokudla

Inkcazelo ebonakalayo yokukunceda ukuba ufumane ifomathi yesisele ukujonga ukulungelelaniswa kwedatha.

Ngokungagqibekanga kwi-Excel, idatha yombhalo ihambelane ngakwesobunxele kwiseli kunye nenombolo yesazisi ngakwesokudla. Ukuba ulungelelwaniso olungagqibekanga lwefomathi olufomathiweyo njengombhalo alutshintshi, amanani angena kuloluhlu kufuneka aboniswe kwicala lesobunxele beeseli njengoko kuboniswe kwiseli C5 kumfanekiso ongentla.

Ukongeza, njengoko kuboniswe kwiiseli ze-A4 ukuya ku-A7, amanani afomathiweyo njengombhalo uya kubonisa unxantathu oluhlaza obuncantsi ekhoneni eliphezulu elingasekhohlo yeseli ebonisa ukuba idatha ingafomathiwe ngokungalunganga.