Yuav Ua Li Cas Hloov Commas rau Lub Sijhawm hauv Microsoft Excel: 11 Kauj Ruam

Cov txheej txheem:

Yuav Ua Li Cas Hloov Commas rau Lub Sijhawm hauv Microsoft Excel: 11 Kauj Ruam
Yuav Ua Li Cas Hloov Commas rau Lub Sijhawm hauv Microsoft Excel: 11 Kauj Ruam

Video: Yuav Ua Li Cas Hloov Commas rau Lub Sijhawm hauv Microsoft Excel: 11 Kauj Ruam

Video: Yuav Ua Li Cas Hloov Commas rau Lub Sijhawm hauv Microsoft Excel: 11 Kauj Ruam
Video: Разблокировать Adobe Flash Player заблокирован в Google Chrome || Исправить содержимое Adobe Flash было заблокировано на краю 2024, Tej zaum
Anonim

Qhov wikiHow no qhia koj yuav ua li cas hloov tus lej cim rau lub sijhawm hauv Microsoft Excel. Hloov tus lej cim nrog lub sijhawm ua haujlwm hauv Excel yeej siv sijhawm ntau. Tej zaum koj yuav tsum tau hloov pauv vim tias Indonesia siv tus lej cim ua cov lej sib cais tsis siv sijhawm. Hmoov zoo, qhov teeb meem no tuaj yeem daws tau yooj yim.

Kauj ruam

Txoj Kev 1 ntawm 2: Siv Nrhiav & Xaiv Cov Cuab Yeej

Hloov Cov Cim rau Dot hauv Excel Kauj Ruam 1
Hloov Cov Cim rau Dot hauv Excel Kauj Ruam 1

Kauj Ruam 1. Qhib Excel daim ntawv uas koj xav tau hloov kho tshiab

Nrhiav cov ntawv nthuav tawm, txawm nyob ntawm lub desktop lossis hauv daim nplaub tshev thiab ob npaug nias rau cov ntawv kom qhib nws.

Hloov Cov Cim rau Dot hauv Excel Kauj Ruam 2
Hloov Cov Cim rau Dot hauv Excel Kauj Ruam 2

Kauj ruam 2. Nyem rau Nrhiav & Xaiv khawm

Nws yog nyob rau sab xis-sab xis ntawm qhov screen. Ib qho ntxiv, lub pob muaj "Nrhiav & Xaiv" thiab tau qhia los ntawm lub iav tsom iav lossis lub cim tsom iav, nyob ntawm qhov Excel version koj siv.

Hloov Cov Lus Cim rau Dot hauv Excel Kauj Ruam 3
Hloov Cov Lus Cim rau Dot hauv Excel Kauj Ruam 3

Kauj Ruam 3. Nyem Hloov los ntawm cov ntawv qhia zaub mov

Tom qab ntawv, cov ntawv qhia zaub mov yuav tshwm thiab " Hloov "Yog thib ob rau hauv qab, tsuas yog sab laug ntawm lub cim xub ntawm cov tsiaj ntawv" b "thiab" c ".

Hloov Cov Lus Cim rau Dot hauv Excel Kauj Ruam 4
Hloov Cov Lus Cim rau Dot hauv Excel Kauj Ruam 4

Kauj Ruam 4. Sau rau hauv daim teb

Lub qhov rai tshiab yuav qhib thiab tso tawm ob kab lus, "Nrhiav dab tsi" thiab "Hloov nrog". Hauv qhov "Nrhiav dab tsi" teb, ntaus tus lej. Hauv qhov "Hloov nrog" teb, ntaus lub sijhawm.

Hloov Cov Lus Cim rau Dot hauv Excel Kauj Ruam 5
Hloov Cov Lus Cim rau Dot hauv Excel Kauj Ruam 5

Kauj Ruam 5. Nyem Hloov Tag Nrho

Thaum qhov kev xaiv raug nyem, txhua tus lej hauv daim ntawv yuav raug hloov pauv mus rau lub sijhawm.

Txoj Kev 2 ntawm 2: Hloov Tus Zauv Separator

Hloov tus lej rau Dot hauv Excel Kauj Ruam 6
Hloov tus lej rau Dot hauv Excel Kauj Ruam 6

Kauj Ruam 1. Qhib Excel daim ntawv uas koj xav tau hloov kho tshiab

Nrhiav cov ntawv spreadsheet, ntawm lub desktop lossis hauv daim nplaub tshev thiab ob npaug nias rau cov ntawv kom qhib nws.

Hloov Cov Cim rau Dot hauv Excel Kauj Ruam 7
Hloov Cov Cim rau Dot hauv Excel Kauj Ruam 7

Kauj Ruam 2. Nyem Cov Ntaub Ntawv hauv lub ces kaum sab sauv sab laug ntawm lub qhov rais

Pob qhov rooj " Cov ntaub ntawv "Ib txwm yog thawj qhov kev xaiv ntawm cov ntawv qhia zaub mov nyob rau sab saum toj ntawm Microsoft Office cov ntaub ntawv. Koj yuav pom nws nyob rau sab saud sab laug ntawm qhov program program window.

Hloov tus lej rau Dot hauv Excel Kauj Ruam 8
Hloov tus lej rau Dot hauv Excel Kauj Ruam 8

Kauj Ruam 3. Nyem Xaiv nyob hauv kaum sab laug

Cov ntawv qhia zaub mov ntawm sab laug ntawm lub vijtsam yog cim ntsuab. Hauv qab ntawm cov ntawv qhia zaub mov, nyob rau sab laug sab laug ntawm cov ntawv qhia zaub mov, koj tuaj yeem pom qhov kev xaiv Kev xaiv ”.

Hloov Cov Cim rau Dot hauv Excel Kauj Ruam 9
Hloov Cov Cim rau Dot hauv Excel Kauj Ruam 9

Kauj Ruam 4. Nyem Advanced ntawm cov ntawv qhia zaub mov ntawm sab laug

Qhov "Excel Options" qhov rai yuav tshwm thiab thauj lwm cov ntawv qhia zaub mov ntawm nws sab laug. Koj tuaj yeem pom qhov kev xaiv " Advanced "hauv qab" Yooj Yim ntawm Kev Nkag Mus ”.

Hloov tus lej rau Dot hauv Excel Kauj Ruam 10
Hloov tus lej rau Dot hauv Excel Kauj Ruam 10

Kauj Ruam 5. Uncheck lub Use system separators box

Koj tuaj yeem pom qhov kev xaiv no hauv qab " Kho kom raug xaiv " Yeej, lub thawv twb raug zuam. Nyem rau daim tshev kom tshem nws kom lub npov khoob.

Hloov tus lej rau Dot hauv Excel Kauj Ruam 11
Hloov tus lej rau Dot hauv Excel Kauj Ruam 11

Kauj Ruam 6. Hloov kho qhov Decimal separator column thiab Txhiab cais cais raws li xav tau.

Ib ntawm kab ntawv no yuav tso tawm tus lej, nyob ntawm qhov ua haujlwm/lub ntsiab ntawm qhov haujlwm. Hloov tus lej nrog lub sijhawm thiab nyem "OK" hauv qab ntawm lub qhov rais kom ua tiav qhov kev hloov pauv.

Pom zoo: