Pehea e hoʻololi ai pehea e hōʻike ai ʻo Excel i nā helu maikaʻi ʻole
Hōʻike ʻo Microsoft Excel i nā helu maikaʻi ʻole me kahi hōʻailona hōʻemi alakaʻi ma ka paʻamau. He hana maikaʻi ia e hoʻomaʻamaʻa maʻalahi i nā helu maikaʻi ʻole, a inā ʻaʻole ʻoe hauʻoli i kēia hoʻonohonoho paʻamau, hāʻawi ʻo Excel i kekahi mau koho ʻokoʻa no ka hoʻopili ʻana i nā helu ʻino.
Hāʻawi ʻo Excel i ʻelua ala i kūkulu ʻia e hōʻike i nā helu maikaʻi ʻole, a hiki iā ʻoe ke hoʻonohonoho i kahi ʻano maʻamau. E luʻu kākou.
E hoʻololi i kahi koho helu ʻino i kūkulu ʻia
Hoʻokahi mea e ʻike ai ma aneʻi, e hōʻike ʻo Excel i nā koho i kūkulu ʻia e pili ana i ka ʻāina o kāu ʻōnaehana hana a me nā hoʻonohonoho ʻōlelo.
No ka poʻe ma ʻAmelika Hui Pū ʻIa, hāʻawi ʻo Excel i nā koho i kūkulu ʻia no ka hōʻike ʻana i nā helu maikaʻi ʻole:
- Ma ka ʻeleʻele me kahi hōʻailona hōʻemi mua
- i ka ʻulaʻula
- nā pale (hiki iā ʻoe ke koho ʻulaʻula a ʻeleʻele paha)
Ma UK a me nā ʻāina ʻē aʻe he nui o ʻEulopa, hiki iā ʻoe ke hoʻonohonoho i nā helu maikaʻi ʻole e ʻike ʻia i ka ʻeleʻele a i ʻole ka ʻulaʻula me ka ʻole a i ʻole ka hōʻailona hōʻemi (ma nā kala ʻelua) akā ʻaʻohe āu koho o nā pale. Hiki iā ʻoe ke aʻo hou aʻe e pili ana i kēia mau hoʻonohonoho kūloko ma Pūnaewele Microsoft .
ʻAʻohe mea i hea ʻoe, hiki iā ʻoe ke hoʻohui i nā koho hou aʻe ma o ka hoʻopilikino ʻana i ke ʻano helu, a mākou e uhi ai ma ka ʻāpana aʻe.
No ka hoʻololi ʻana i kahi ʻano ʻokoʻa i kūkulu ʻia, kaomi ʻākau ma kahi keena (a i ʻole ka laulā o nā cell i koho ʻia) a kaomi i ke kauoha Format Cells. Hiki iā ʻoe ke kaomi iā Ctrl + 1.
Ma ka pukaaniani Format Cells, e hoʻololi i ka pā helu. Ma ka ʻaoʻao hema, koho i ka ʻāpana "Number". Ma ka ʻaoʻao ʻākau, koho i kahi koho mai ka papa inoa Negative Numbers a kaomi iā OK.
E hoʻomaopopo i ke kiʻi ma lalo e hōʻike ana i nā koho āu e ʻike ai ma US. E kamaʻilio mākou e pili ana i ka hana ʻana i kāu mau hoʻolālā maʻamau i ka ʻāpana aʻe, no laila ʻaʻohe pilikia inā ʻaʻole i hōʻike ʻia ka mea āu e makemake ai.
Maanei, ua koho mākou e hōʻike i nā waiwai maikaʻi ʻole i ka ʻulaʻula me nā pale.
ʻOi aku ka maʻalahi o kēia ʻike ma mua o ka Excel paʻamau.
E hana i kahi ʻano helu ʻino maʻamau
Hiki iā ʻoe ke hana i kāu mau helu helu ma Excel. Hāʻawi kēia iā ʻoe i ka mana piha i ka hōʻike ʻana o ka ʻikepili.
E hoʻomaka ma ke kaomi ʻana i ke kelepona (a i ʻole ka laulā o nā cell i koho ʻia) a laila kaomi i ke kauoha Format Cells. Hiki iā ʻoe ke kaomi iā Ctrl + 1.
Ma ka helu helu, koho i ka ʻāpana Custom ma ka hema.
E ʻike ʻoe i kahi papa inoa o nā ʻano hana maʻamau ma ka ʻākau. Me he mea lā ua huikau paha kēia i ka wā mua akā ʻaʻohe pono e makaʻu.
Hoʻokaʻawale ʻia kēlā me kēia ʻano maʻamau i ʻehā mau ʻāpana, me kēlā me kēia ʻāpana i hoʻokaʻawale ʻia e kahi semicolon.
ʻO ka ʻāpana mua no nā waiwai maikaʻi, ʻo ka lua no nā mea ʻino, ʻo ke kolu no nā waiwai ʻole, a ʻo ka pauku hope no ke kikokikona. ʻAʻole pono ʻoe e hoʻopili i nā ʻāpana āpau.
E like me ka laʻana, e hana kāua i kahi hōʻano helu maikaʻi ʻole e pili ana i kēia mau mea a pau.
- i ka uliuli
- ma waena o nā pale
- ʻAʻohe wahi decimal
I ka pahu Type, e hoʻokomo i ke code ma lalo nei.
#, ## 0; [Pulilu] (#, ##0)
He manaʻo ko kēlā me kēia hōʻailona, a ma kēia ʻano, hōʻike ka # i ka hōʻike ʻana o kahi helu koʻikoʻi, a ʻo 0 ka hōʻike ʻana o kahi helu nui ʻole. Aia kēia helu ʻino i loko o nā pale a hōʻike pū ʻia i ka uliuli. Aia he 57 mau kala like ʻole e hiki iā ʻoe ke kuhikuhi ma ka inoa a i ʻole ka helu ma kahi waihona helu maʻamau. E hoʻomanaʻo e hoʻokaʻawale kahi semicolon i ka hōʻike ʻana o kahi helu maikaʻi a me ka helu ʻino.
Eia kā mākou hopena:
ʻO ka hoʻopololei maʻamau he akamai kūpono ma Excel. Hiki iā ʻoe ke hana i kahi ʻano e hoʻopau i nā hoʻonohonoho maʻamau i loaʻa ma Excel ʻaʻole lawa paha no kāu mau pono. ʻO ka hoʻopili ʻana i nā helu ʻino kekahi o ka hoʻohana maʻamau o kēia hāmeʻa.
