txheem
Hauv kev ua haujlwm ntawm Excel program, txhua yam ua haujlwm raws li cov qauv qhia thiab kev ua haujlwm. Txawm hais tias vim muaj ib qho chaw lossis cov cim cim, tag nrho cov ntawv khaws cia tuaj yeem ua tsis tiav. Thiab qhov no txhais tau hais tias nws yuav muaj txiaj ntsig zoo rau txhua tus neeg siv ntawm qhov kev pab cuam kom kawm sai sai nrhiav qhov yuam kev ua thiab kho nws.
Tus txheej txheem hloov tshiab
Nyob rau hauv lub version ntawm Excel, ib tug comma yog siv los qhia cov zauv feem, tab sis nyob rau hauv lub English program, dots yog siv. Feem ntau qhov yuam kev no tshwm sim vim ua haujlwm ob hom lus lossis vim tsis muaj kev paub.
Yuav pib nrog, nws tsim nyog txiav txim siab txog cov laj thawj vim li cas nws thiaj li tsim nyog los hloov lub cim nrog lub cim. Qee qhov xwm txheej, qhov no yog vim muaj qhov pom kev zoo nkauj dua li qhov yuav tsum tau ua. Tab sis yog tias qhov kev hloov pauv yuav tsum tau hais los ntawm qhov xav tau ntawm kev suav, ces kev xaiv ntawm ib txoj hauv kev los hloov commas nrog dots yuav tsum tau ua tiag tiag. Nyob ntawm lub hom phiaj ntawm kev hloov, txoj kev yuav txawv.
Txoj Kev 1: Siv Qhov Nrhiav thiab Hloov Cov Cuab Yeej
Ib txoj hauv kev yooj yim tshaj plaws thiab paub zoo tshaj plaws los hloov lub cim nrog lub cim yog siv lub cuab yeej hu ua Nrhiav thiab Hloov. Hmoov tsis zoo, txoj kev no tsis haum rau kev ua haujlwm feem. Thaum hloov lub comma nrog ib lub dot siv txoj kev no, cov txiaj ntsig ntawm tes yuav hloov mus rau hauv cov ntawv nyeem. Xav txog cov txheej txheem ntawm Nrhiav thiab Hloov Txoj Kev:
- Peb xaiv cov kab mob tshwj xeeb uas yuav tsum tau hloov. Thaum koj right-click rau ntawm qhov chaw xaiv, cov ntawv qhia zaub mov pops. Ntawm no peb xaiv cov khoom hu ua "Format Cells". Cov haujlwm no tuaj yeem raug hu los ntawm cov keyboard shortcut Ctrl + 1.
- Thaum "Format Cells" qhib, lub qhov rai formatting qhib. Hauv qhov "Number" parameter, xaiv "Text" cov txheej txheem. Txhawm rau txuag cov kev hloov pauv, nco ntsoov nyem "OK". Yog tias koj cia li kaw lub qhov rais formatting, ces txhua qhov kev hloov pauv yuav poob lawv cov txiaj ntsig.
- Cia peb mus rau kauj ruam tom ntej. Ntxiv dua thiab, xaiv cov xov tooj xav tau ntawm cov hlwb. Nyob rau hauv lub tab tab "Tsev" peb pom qhov thaiv ntawm kev ua haujlwm "Editing", xaiv "Nrhiav thiab xaiv". Hauv cov ntawv qhia zaub mov uas tshwm tom qab qhov no, qhov kev xaiv "Hloov" yuav tsum qhib.
- Tom ntej no, lub qhov rais hu ua "Nrhiav thiab Hloov" qhib los sau ob "Nrhiav" tsis - tus cim, lo lus lossis tus lej nkag, thiab hauv "Hloov nrog" koj yuav tsum qhia tus cwj pwm, lo lus lossis tus lej uas yuav hloov pauv. ua. Yog li, nyob rau hauv kab "Nrhiav" yuav muaj ib tug "," cim, thiab nyob rau hauv kab "Hloov nrog" - "."
- Tom qab sau cov kev txwv, nyem "Hloov tag nrho". Tom qab ntawd, cov lus me me yuav tshwm sim txog cov lej hloov pauv. Nyem "OK".
Txoj kev no tso cai rau koj los hloov tag nrho cov commas nrog lub sijhawm nyob rau hauv qhov chaw xaiv ntawm cov cell. Cov txheej txheem yog yooj yim thiab ceev. Qhov tsis zoo ntawm txoj kev no yog kev hloov ntawm hom ntawv nrog cov ntawv nyeem, uas tsis suav nrog kev suav ntxiv.
Txoj Kev 2: Siv SUBSTITUTE Function
Cov txheej txheem yog raws li kev siv cov kev ua haujlwm ntawm tib lub npe. Thaum xaiv hom no, nws yog ib qho tsim nyog los hloov cov ntaub ntawv ntawm tes, thiab tom qab ntawd luam nws thiab muab tso rau hauv qhov chaw ntawm cov ntaub ntawv qub.
- Los ntawm kev xaiv ib lub xov tooj khoob, ib sab ntawm lub xov tooj ntawm tes uas yuav hloov pauv. Qhib "Insert function" - lub cim nyob rau hauv kab ntawm functions "fx".
- Hauv qhov rai uas tshwm nrog cov haujlwm muaj, peb pom qhov "Text" ntu ntu. Xaiv cov qauv hu ua "Substitute" thiab txuag kev xaiv los ntawm nias lub pob "OK".
- Lub qhov rais tshwm rau kev sau cov ntawv yuav tsum tau - "Text", "Cov ntawv qub" thiab "Cov ntawv tshiab". Qhov "Text" parameter yuav nkag mus rau qhov chaw nyob ntawm tes nrog tus nqi qub. Cov kab "Cov ntawv qub" yog npaj los qhia tus cwj pwm los hloov, uas yog, ",", thiab hauv "Cov ntawv tshiab" peb nkag mus rau "." Thaum tag nrho cov tsis tau sau rau hauv, nyem OK. Cov hauv qab no yuav tshwm sim nyob rau hauv lub active cell: =SUBSTITUTE(C4; “,”; “.”).
- Raws li qhov tshwm sim, tus nqi ntawm tes hloov pauv tau zoo. Cov kev hloov pauv no yuav tsum rov ua dua rau tag nrho lwm cov hlwb.
- Txoj kev no kuj muaj qhov tsis zoo. Yog tias tsuas yog ob peb qhov tseem ceeb yuav tsum tau hloov, ces rov ua cov kauj ruam yuav tsis siv sij hawm ntau. Tab sis yuav ua li cas yog tias koj xav tau hloov cov ntaub ntawv loj loj. Koj tuaj yeem, piv txwv li, siv lub xov tooj ntawm tes sau tus cim.
- Txhawm rau siv cov khoom no, koj yuav tsum teeb tus cursor mus rau sab xis sab xis ntawm lub xov tooj ntawm tes nrog cov haujlwm uas twb tau nkag lawm. Nyob rau hauv cov ntaub ntawv no, ib tug ntoo khaub lig yuav tshwm - lub thiaj li hu ua sau marker. Los ntawm txhaj rau sab laug nas khawm, koj yuav tsum rub tus ntoo khaub lig raws kab nrog rau qhov tseem ceeb uas yuav tsum tau hloov.
- Raws li qhov tshwm sim, cov txiaj ntsig tau hloov pauv lawm yuav tshwm sim hauv kab xaiv - tsis yog cov cim hauv cov zauv feem, tam sim no muaj cov dots. Tam sim no koj yuav tsum luam thiab hloov tag nrho cov txiaj ntsig tau hloov pauv mus rau lub hlwb ntawm tus lej qub. Teeb pom kev hloov pauv. Nyem qhov "Copy" khawm nyob rau hauv lub "Main" tab.
- Thaum koj right-click lub khoos phis tawj nas ntawm cov cell xaiv, cov ntawv qhia zaub mov tshwm nrog qeb "Paste Options", nrhiav thiab xaiv qhov "Values" parameter. Schematically, cov khoom no yog tso tawm raws li ib tug khawm "123".
- Cov nqi hloov pauv yuav raug hloov mus rau cov hlwb tsim nyog. Txhawm rau tshem tawm cov txiaj ntsig tsis tsim nyog hauv tib cov ntawv qhia zaub mov, xaiv qeb "Clear contents".
Yog li, kev hloov ntawm commas rau lub sij hawm nyob rau hauv qhov kev xaiv ntawm qhov tseem ceeb tau ua tiav, thiab cov nqi tsis tsim nyog tau raug tshem tawm.
Txoj Kev 3: Kho Excel Options
Los ntawm kev kho qee qhov kev txwv ntawm Excel program, koj tuaj yeem ua tiav qhov hloov pauv ntawm lub cim "," nrog ".". Nyob rau hauv cov ntaub ntawv no, cov hom ntawm cov cell yuav nyob twj ywm tus lej, thiab yuav tsis hloov mus rau cov ntawv nyeem.
- Los ntawm qhib lub "Cov ntaub ntawv" tab, xaiv "Options" thaiv.
- Koj yuav tsum mus rau qeb "Advanced" thiab nrhiav "Editing Options". Uncheck lub thawv nyob ib sab ntawm "Siv system separators" cov txheej txheem. Nyob rau hauv kab "Separator of integer and fractional parts" peb hloov lub dot, uas yog los ntawm lub neej ntawd, mus rau ib qho comma.
Tom qab cov kev hloov pauv tau ua nyob rau hauv Excel qhov kev teeb tsa, qhov kev txwv rau denoting feem yog tam sim no lub sijhawm.
Txoj Kev 4: Siv lub Custom Macro
Lwm txoj hauv kev hloov semicolons hauv Excel suav nrog kev siv macros. Tab sis ua ntej siv lawv, koj yuav tsum coj mus rau hauv tus account qhov tseeb tias macros yog neeg xiam los ntawm lub neej ntawd hauv qhov kev pab cuam. Yog li, txhawm rau pib, koj yuav tsum qhib lub "Developer" tab thiab qhib macros.
Lub hom "Developer" yog enabled los ntawm qhov kev pab cuam nqis. Hauv ntu ntu hu ua "Customize the ribbon", tom qab ntawd hauv qeb "Main tabs" peb pom cov khoom "Developer", nyob rau hauv pem hauv ntej ntawm peb muab zuam. Cov chaw qhib tau qhib tom qab nias lub pob "OK".
- Tab "Developer" → thaiv "Code", nias lub pob hu ua "Visual Basic".
- Lub qhov rais macro editor yuav qhib. Hauv qhov rai no, koj yuav tsum nkag mus rau hauv cov program code hauv qab no:
Nyob rau theem no, peb ua tiav cov haujlwm hauv tus editor los ntawm kev kaw lub qhov rais editor.
- Xaiv cov hlwb uas yuav hloov pauv. Nias lub pob "Macros", uas nyob rau hauv lub toolbox.
- Ib lub qhov rais tshwm qhia cov macros muaj. Xaiv cov macro tsim tshiab. Nrog cov macro xaiv, nyem "Khiav" kom qhib nws.
- Kev hloov pauv tau ua tiav - cov dots tau tshwm sim tsis yog commas.
Daim ntawv thov ntawm txoj kev no yuav tsum tau saib xyuas tshwj xeeb. Tom qab qhib lub macro, nws tsis tuaj yeem rov qab txhua yam rov qab. Thaum xaiv cov cell nrog qee qhov tseem ceeb, koj yuav tsum xyuas kom meej tias cov kev hloov pauv tsuas yog ua rau cov ntaub ntawv uas xav tau tiag tiag.
Txoj Kev 5: Hloov lub computer qhov system nqis
Txoj kev no tsis yog ntau heev, txawm li cas los xij, nws kuj tseem siv los hloov cov cim nrog lub sijhawm thaum ua kev suav hauv Excel cov ntaub ntawv. Peb yuav hloov qhov chaw ncaj qha hauv software. Xav txog cov txheej txheem no siv qhov piv txwv ntawm Windows 10 Pro software.
- Peb mus rau "Control Vaj Huam Sib Luag", uas tuaj yeem raug hu los ntawm "Start".
- Hauv qeb "Lub Sijhawm thiab hom lus", xaiv qhov "Region" kev xaiv.
- Tom qab ntawd, lub qhov rais yuav qhib. Ntawm no peb qhib "Kev xaiv ntxiv rau hnub tim, sijhawm, thaj tsam".
- Lub qhov rais tshiab yuav qhib, nyob rau hauv uas peb mus rau "Regional Standards".
- Tam sim no mus rau "Formats" tab thiab hauv qab ntawm lub qhov rais qhib "Advanced xaiv ...".
- Tom ntej no, nyob rau hauv qeb "Numbers", qhia qhov yuav tsum tau cais cim nyob rau hauv kab "Separator of the integer and fractional parts." Tom qab ua qhov hloov pauv, nyem "OK".
Raws li qhov tshwm sim ntawm peb txoj haujlwm, commas nyob rau hauv cov hlwb-thaj chaw ntawm Excel cov ntxhuav uas muaj cov lej lej yuav raug hloov pauv mus rau lub sijhawm. Nyob rau hauv cov ntaub ntawv no, lub cell hom tsis muaj teeb meem, txawm nws yog "General" los yog "Numeric".
Tseem ceeb! Thaum xa cov ntaub ntawv mus rau lwm lub khoos phis tawj nrog cov qauv teeb tsa, teeb meem nrog cov txheej txheem suav yuav tshwm sim.
Txoj Kev Ntxiv: Hloov lub cim nrog lub cim cim hauv Excel siv Notepad
Windows software muaj qhov kev pab cuam Notepad uas ua haujlwm raws li qhov tsawg kawg nkaus ntawm kev ua haujlwm thiab kev teeb tsa. "Notepad" tuaj yeem siv los ua tus neeg nruab nrab rau kev luam, saib ua ntej cov ntaub ntawv.
- Koj yuav tsum xaiv qhov xav tau ntau ntawm cov hlwb thiab luam nws. Qhib Notepad thiab muab tshuaj txhuam qhov tseem ceeb rau hauv lub qhov rais uas qhib.
- Hauv "Hloov" tab, xaiv "Hloov" qeb. Raws li cov yuam sij kub, kev sib xyaw "CTRL + H" yog siv. Ib lub qhov rais tshwm nyob rau hauv uas peb sau rau hauv cov teb. Hauv kab "Dab tsi" nkag mus "," hauv kab "Dab tsi" - "." Thaum cov teb tiav lawm, nyem "Hloov tag nrho".
Tom qab cov kev hloov pauv no hauv cov ntawv sau, tag nrho cov cim tau hloov pauv mus rau lub sijhawm. Tam sim no nws tseem tsuas yog luam tawm qhov hloov pauv qhov tseem ceeb uXNUMXbuXNUMXbagain thiab muab tso rau hauv lub rooj ntawm Excel daim ntawv.
xaus
Kab lus tau tshuaj xyuas cov kev ua tau zoo tshaj plaws thiab nrov tshaj plaws rau kev hloov cov cim cim hauv cov zauv feem ntau nrog cov dots hauv Excel spreadsheets. Feem ntau, cov neeg siv nyiam cov cuab yeej hauv Nrhiav thiab Hloov cov cuab yeej rau qhov pom kev pom zoo ntawm cov lej muaj txiaj ntsig, thiab SUBSTITUTE muaj nuj nqi yog siv los ua kev suav.