Hōʻike i nā pākēneka ma Excel

Ma kēia haʻawina liʻiliʻi e ʻike ʻoe i nā ʻike pono e pili ana ʻano pākēneka ma Excel. E aʻo ʻoe pehea e hoʻololi ai i ke ʻano o ka ʻikepili i loaʻa i pakeneka, pehea e hoʻonohonoho ai i ka hōʻike o nā pākēneka i loko o ke kelepona, a me ka hoʻololi ʻana i nā helu i nā pākēneka ke hoʻokomo lima ʻia.

Ma Microsoft Excel, maʻalahi loa ka hōʻike ʻana i nā waiwai ma ke ʻano he pākēneka. No ka hana ʻana i kēia, koho i hoʻokahi a ʻoi aku paha nā cell a kaomi i ke pihi Keʻano pākēneka (pakeneka format) ma ka pauku Number (Helu) tabs Home (Home):

Hiki iā ʻoe ke hana wikiwiki aʻe ma ke kaomi ʻana i ka pōkole keyboard Ctrl+Shift+%. E hoʻomanaʻo ʻo Excel iā ʻoe i kēia hui ʻana i kēlā me kēia manawa āu e lele ai ma luna o ke pihi. Keʻano pākēneka (pakeneka format).

ʻAe, Hōʻano pākēneka ma Excel hiki ke hoʻonohonoho i hoʻokahi kaomi. Akā ʻokoʻa ka hopena ma muli o ke noi ʻana i ka formatting i nā waiwai i loaʻa a i ʻole nā ​​​​pūnaewele ʻole.

• Hōʻano i nā waiwai i loaʻa ma ke ʻano he pākēneka
• E hoʻopili i ka hōʻano pākēneka i nā keena hakahaka
• E hōʻike i nā helu ma ke ʻano he pākēneka i kou paʻi ʻana
• Nā hoʻopunipuni i ka hōʻike ʻana i nā pākēneka ma Excel

Hōʻano i nā waiwai i loaʻa ma ke ʻano he pākēneka

Ke noi ʻoe Hōʻano pākēneka No nā pūnaewele i loaʻa i nā waiwai helu, hoʻonui ʻo Excel i kēlā mau waiwai me 100 a hoʻohui i kahi hōʻailona pākēneka (%) ma ka hopena. Mai ka manaʻo o Excel, pololei kēia, no ka mea, ʻo ka 1% ka hapa haneri.

Eia naʻe, i kekahi manawa ke alakaʻi nei kēia i nā hopena i manaʻo ʻole ʻia. No ka laʻana, inā loaʻa i ka cell A1 ka helu 20 a pili ʻoe i kēia cell Hōʻano pākēneka, a laila e loaʻa iā ʻoe ka 2000%, ʻaʻole 20% e like me kāu i makemake ai.

Pehea e pale ai i ka hewa:

• Inā loaʻa i kahi kelepona i kāu papaʻaina nā helu ma ke ʻano helu maʻamau, a pono ʻoe e hoʻololi iā lākou i loko pakeneka, e puunaue mua i keia mau helu me ka 100. No ka la'ana, ina i kakauia kou ikepili mua ma ke kolamu A, hiki ia oe ke hookomo i ka huahelu ma ka cell B2. =A2/100 a kope iā ia i nā pūnaewele pono a pau o ke kolamu B. A laila, koho i ke kolamu B holoʻokoʻa a pili iā ia Hōʻano pākēneka. Pono ka hopena e like me kēia:Hiki iā ʻoe ke hoʻololi i nā kumu hoʻohālike ma ke kolamu B me nā waiwai, a laila kope iā lākou i ke kolamu A a holoi i ke kolamu B inā ʻaʻole pono ʻoe.
• Inā pono ʻoe e hoʻololi i kekahi o nā waiwai i ka pākēneka, hiki iā ʻoe ke hoʻokomo iā lākou me ka lima ma ka puʻunaue ʻana i ka helu me 100 a kākau iā ia ma ke ʻano he decimal. No ka laʻana, no ka loaʻa ʻana o ka waiwai 28% ma ke kelepona A2 (e ʻike i ke kiʻi ma luna), e hoʻokomo i ka helu 0.28, a laila e hoʻopili iā ia. Hōʻano pākēneka.

E hoʻopili i ka hōʻano pākēneka i nā keena hakahaka

Ua ʻike mākou i ke ʻano o ka hoʻololi ʻana o ka hōʻike ʻana o ka ʻikepili i loaʻa i kahi pāpalapala Microsoft Excel ke hoʻololi ʻoe i ka ʻano helu maʻalahi i pakeneka. Akā he aha ka hopena inā pili mua ʻoe i kahi kelepona Hōʻano pākēneka, a laila e hoʻokomo i kahi helu i loko me ka lima? ʻO kēia kahi e hiki ai iā Excel ke hana ʻokoʻa.

• E kākau wale ʻia kekahi helu i like a ʻoi aku paha me ka hōʻailona %. No ka laʻana, e kākau ʻia ka helu 1 ma ke ʻano he 2%; 2 - like me 20%; 20 - like me 2,1% a pēlā aku.
• E hoʻonui ʻia nā helu liʻiliʻi ma mua o 1 me ka ʻole o ka 0 ma ka hema o ka helu decimal me 100. No ka laʻana, inā ʻoe e paʻi. ,2 i loko o kahi keena me ka helu pākēneka, e ʻike ʻoe i kahi waiwai o 20% ma muli o ka hopena. Eia naʻe, inā ʻoe e paʻi ma ka papa keyboard 0,2 i loko o ke kelepona hoʻokahi, e kākau ʻia ka waiwai e like me 0,2%.

E hōʻike i nā helu ma ke ʻano he pākēneka i kou paʻi ʻana

Inā ʻoe e hoʻokomo i ka helu 20% (me ka hōʻailona pākēneka) i loko o kahi kelepona, e hoʻomaopopo ʻo Excel makemake ʻoe e kākau i ka waiwai ma ke ʻano he pākēneka a hoʻololi maʻalahi i ke ʻano o ke kelepona.

Hoʻolaha nui!

I ka hoʻohana ʻana i ka helu pākēneka ma Excel, e ʻoluʻolu e hoʻomanaʻo ʻaʻole kēia he mea ʻē aʻe ma mua o kahi hiʻohiʻona ʻike o ka waiwai makemakika maoli i mālama ʻia i loko o kahi keena. ʻOiaʻiʻo, mālama mau ʻia ka pākēneka ma ke ʻano he decimal.

Ma nā'ōlelo'ē aʻe, mālamaʻia ka 20% e like me 0,2; Mālama ʻia ka 2% e like me 0,02 a pēlā aku. Ke hana ʻia nā helu like ʻole, hoʻohana ʻo Excel i kēia mau waiwai, ʻo ia hoʻi nā hakina decimal. E hoʻomanaʻo i kēia i ka wā e hoʻokumu ai i nā formula e pili ana i nā cell me nā pākēneka.

E ʻike i ka waiwai maoli i loko o kahi kelepona i loaʻa Hōʻano pākēneka:

1. E kaomi ʻākau iā ia a koho mai ka papa kuhikuhi Nā Kelepona Hōʻike a i ʻole ka hui pū ʻana CTRL+1.
2. I ka pahu kamaʻilio e kū mai ana Nā Kelepona Hōʻike (Cell Format) e nānā i kahi hāpana (Laʻana) ʻaoʻao Number (Helu) ma ka waeʻano Nui (General).

Nā hoʻopunipuni i ka hōʻike ʻana i nā pākēneka ma Excel

Me he mea lā ʻo ka helu ʻana a me ka hōʻike ʻana i ka ʻikepili ma ke ʻano he pākēneka kekahi o nā hana maʻalahi a mākou e hana ai me Excel. Akā ʻike nā mea hoʻohana ʻike ʻaʻole maʻalahi kēia hana.

1. E hoʻonoho i ka hōʻike i ka helu i makemake ʻia o nā wahi decimal

i ka wa Hōʻano pākēneka pili i nā helu, hōʻike ʻo Excel 2010 a me 2013 i kā lākou waiwai i hoʻopuni ʻia i kahi helu holoʻokoʻa, a i kekahi mau hihia hiki ke alakaʻi hewa kēia. No ka laʻana, e hoʻonoho i kahi ʻano pākēneka i kahi kelepona ʻole a hoʻokomo i kahi waiwai o 0,2% i loko o ke kelepona. He aha i hana ai? ʻIke wau i ka 0% i kaʻu papaʻaina, ʻoiai ʻike maopopo wau he 0,2%.

No ka ʻike ʻana i ka waiwai maoli a ʻaʻole ka waiwai pōʻai, pono ʻoe e hoʻonui i ka helu o nā wahi decimal e hōʻike ʻia e Excel. No kēia:

1. E wehe i kahi pahu kamaʻilio Nā Kelepona Hōʻike (Hoʻopololei i nā cell) me ka hoʻohana ʻana i ka papa kuhikuhi pōʻaiapili, a i ʻole e kaomi i ka hui kī CTRL+1.
2. E koho i ka waeʻano pakeneka (Pakeneka) a hoʻonoho i ka helu o nā wahi decimal i hōʻike ʻia i loko o ke kelepona e like me kou makemake.
3. Ke mākaukau nā mea a pau, kaomi OKno ka hoʻololiʻana i nā loli.

2. E hōʻike i nā waiwai maikaʻi ʻole me ka hoʻohālikelike ʻana

Inā makemake ʻoe e hōʻike ʻokoʻa nā waiwai maikaʻi ʻole, e like me ka ʻulaʻula, hiki iā ʻoe ke hoʻonohonoho i kahi ʻano helu maʻamau. E wehe hou i ke kamaʻilio Nā Kelepona Hōʻike (Format cell) a hele i ka pā Number (Helu). E koho i ka waeʻano Mana Lima (All Formats) a komo i ke kahua ʻAno kekahi o kēia mau laina:

• 00%;[Red]-0.00% or 00%;[ʻulaʻula]-0,00% - hōʻike i nā waiwai pākēneka maikaʻi i ka ʻulaʻula a hōʻike i 2 mau wahi decimal.
• 0%;[ʻulaʻula]-0% or 0%; [Krahiamoe]-0% - hōʻike i nā waiwai pākēneka maikaʻi i ka ʻulaʻula a ʻaʻole hōʻike i nā waiwai ma hope o ka helu decimal.

Hiki iā ʻoe ke aʻo hou aʻe e pili ana i kēia ʻano hoʻohālikelike ma ka Microsoft reference, ma ke kumuhana e hōʻike ana i nā helu ma ka pākēneka.

3. Hoʻopili i nā waiwai pākēneka maikaʻi ʻole ma Excel me ka hoʻohālikelike ʻana

Ke hoʻohālikelike ʻia i ke ʻano ma mua, ʻo ke ʻano hoʻohālikelike kūlana ma Excel kahi ala maʻalahi e hiki ai iā ʻoe ke hoʻonohonoho i kekahi ʻano no ke kelepona i loaʻa i kahi waiwai pākēneka maikaʻi ʻole.

ʻO ke ala maʻalahi loa e hana i kahi lula hoʻopono kūlana ʻo ka hele ʻana i ka papa kuhikuhi Hoʻonohonoho kūlana > Hoʻokaʻawale i nā lula > Ua emi (Ka Hōʻuluʻulu Kūlana > Nā lula koho kelepona > Liʻiliʻi ma mua…) a komo i ka 0 i ke kahua Hōʻano i nā pūnaewele i emi iho (E hōʻano i nā pūnaewele i emi iho)

A laila, ma ka papa inoa hāʻule iho, hiki iā ʻoe ke koho i kekahi o nā koho maʻamau i manaʻo ʻia a kaomi paha Hōʻike Manaʻo (Custom Format) ma ka hope o kēia papa inoa a hoʻopilikino i nā kikoʻī hōʻano kelepona āpau e like me kou makemake.

Eia kekahi mau koho no ka hana pū ʻana me Hōʻano pākēneka wehe ka ʻikepili iā Excel. Manaʻo wau e hoʻopakele ka ʻike i loaʻa mai kēia haʻawina iā ʻoe mai nā poʻo poʻo pono ʻole i ka wā e hiki mai ana. Ma nā ʻatikala aʻe, e luʻu hohonu mākou i ke kumuhana o nā pākēneka ma Excel. E aʻo ʻoe i nā ʻano hana āu e hoʻohana ai no ka helu ʻana i ka hoihoi ma Excel, e aʻo i nā ʻōkuhi no ka helu ʻana i ka hoʻololi pākēneka, ka pakeneka o ka huina, ka ukupanee hui, a me nā mea hou aku.

E noho mālie a hauʻoli i ka heluhelu ʻana!