Kab lus no wikiHow qhia koj yuav hloov pauv tus lej rau tus lej hauv Excel li cas. Kev hloov tus lej cim tus kheej nrog tus lej hauv Excel tuaj yeem ua haujlwm tas sijhawm. Tej zaum koj yuav khiav mus rau qhov xwm txheej no vim yog cov tebchaws nyob sab Europe siv tus lej cim ua tus lej sib cais tsis siv lub sijhawm. Luckily, qhov teeb meem no tuaj yeem kho tau yooj yim heev.
Cov kauj ruam
Txoj Kev 1 ntawm 2: Siv Nrhiav & Xaiv Cov Cuab Yeej
Kauj Ruam 1. Qhib Excel daim ntawv uas koj xav tau hloov tshiab
Txawm hais tias nws nyob ntawm koj lub desktop lossis hauv daim nplaub tshev, nrhiav cov ntawv nthuav tawm thiab ob npaug nias rau nws kom qhib nws.
Kauj ruam 2. Nyem rau ntawm Nrhiav & Xaiv khawm
Lub pob no tuaj yeem pom nyob rau sab xis saum toj ntawm lub vijtsam. Nws yuav hais tias "Nrhiav & Xaiv" thiab nws yuav sawv cev los ntawm lub iav tsom iav lossis tsom iav, nyob ntawm qhov version ntawm Excel koj tab tom siv.
Kauj Ruam 3. Nyem Hloov los ntawm cov ntawv qhia zaub mov
Cov ntawv qhia zaub mov yuav tshwm thiab Hloov yuav yog qhov kev xaiv thib ob, tsuas yog mus rau sab laug ntawm lub cim uas muaj cov xub ntawm cov tsiaj ntawv "b" thiab "c."
Kauj Ruam 4. Sau daim teb
Lub qhov rai yuav qhib nrog ob daim teb: "Nrhiav dab tsi" thiab "Hloov nrog." Hauv qhov "Nrhiav dab tsi" teb, ntaus tus lej. Hauv qhov "Hloov nrog" teb, ntaus lub sijhawm/teev.
Kauj Ruam 5. Nyem Hloov Tag Nrho
Nyem rau qhov kev xaiv no yuav hloov txhua tus cim hauv daim ntawv nrog lub sijhawm/teev.
Txoj Kev 2 ntawm 2: Hloov Tus lej Sib cais
Kauj Ruam 1. Qhib Excel daim ntawv uas koj xav tau hloov tshiab
Txawm hais tias nws nyob ntawm koj lub desktop lossis hauv daim nplaub tshev, nrhiav cov ntawv nthuav tawm thiab ob npaug nias rau nws kom qhib nws.
Kauj Ruam 2. Nyem Cov Ntaub Ntawv nyob rau saum kaum sab laug
Cov Cov ntaub ntawv khawm ib txwm yog thawj qhov kev xaiv nyob rau sab saum toj cov ntawv qhia zaub mov ntawm Microsoft Office. Koj tuaj yeem pom nws nyob rau sab saum toj sab laug ntawm lub qhov rais.
Kauj Ruam 3. Nyem Xaiv hauv qab sab laug
Cov ntawv qhia zaub mov nyob rau sab laug ntawm qhov screen yuav ntsuab. Hauv qab ntawm cov ntawv qhia zaub mov no, hauv qab sab laug ntawm cov ntawv qhia zaub mov, koj yuav pom Kev xaiv.
Kauj Ruam 4. Nyem Advanced hauv cov ntawv qhia zaub mov ntawm sab laug
Lub qhov rai ntawm Excel Options yuav tshwm tuaj uas muaj lwm cov ntawv qhia zaub mov nyob rau sab laug. Koj tuaj yeem pom qhov Advanced kev xaiv hauv qab no Yooj Yim ntawm Kev Nkag Mus.
Kauj Ruam 5. Uncheck lub Use system separators box
Koj tuaj yeem pom qhov kev xaiv no nyob ze rau hauv qab ntawm Kho kom raug xaiv ntu Lub thawv yuav tsum raug tshuaj xyuas los ntawm lub neej ntawd. Nyem rau ntawm lub cim kos kom nws ploj mus, thiab lub npov tsis raug xaiv.
Kauj Ruam 6. Hloov kho qhov Decimal separator thiab Ntau txhiab cais cov teb raws li qhov tsim nyog.
Nyob ntawm seb koj qhov tsis yog, ib qho ntawm cov haujlwm no yuav tsum muaj tus lej hauv nws. Hloov nws nrog lub sijhawm/teev thiab nyem "OK" hauv qab ntawm lub qhov rais kom ua tiav qhov kev hloov pauv.