Raws li nyob rau hauv "Eksele" hloov lub comma point? Configure Excel

Mus siv cov uas twb muaj lawm kev txiav txim ntawm tej yam, peb yuav muab me ntsis xav mus rau lub fact tias ib tug neeg muaj peev xwm nyob rau lwm txoj cai. Nyob rau hauv qhov tseeb, qhov no yog tsis tau hais tias cov Dalai Lama, thiab qhov kev piav qhia ntawm ib qho ntawm cov chaw ua hauj lwm cov teeb meem uas yuav ua rau Excel regional chaw. Nws essence lies nyob rau hauv lub fact tias nyob rau hauv ntau lub teb chaws, txawm siv tib lub Arabic numerals, tus xov tooj yog feem ntau sau ib daim ntawv dog dig txawv. Ib tug piv txwv ntawm no txim hluav taws xob, uas feem ntau ua rau yus muaj teeb meem, yog tus kos npe rau tias cais los ntawm lub fractional ib feem ntawm tag nrho cov. Nyob rau hauv Russia, thiab nyob hauv lub qub Soviet qhov chaw, nws yog ib txwm ib tug tsis nco qab, tab sis nyob rau hauv Western teb chaws - ib tug taw tes.

Lub ntsiab lus ntawm cov nqe lus nyob rau hauv Excel

Cia saib yuav ua li cas undesirable txim tej zaum yuav raug nyob rau hauv lub xub ntiag ntawm ib tug system ntawm "tsis yog" los yog, es mus hais tias, tsis yog delimiter. Nyob rau hauv Feem ntau, ib tug xov tooj uas muaj ib tug taw tes, Excel yuav muab txhais raws li ib hnub, thiab raws li, es tsis txhob "25,11" koj tau txais "25.noyab" cell.

Thaum ua hauj lwm nrog loj nyiaj ntawm cov ntaub ntawv nyob rau hauv ib lub rooj, koj yuav tsis sai li sai tau daim ntawv ceeb toom no transformation. Qhov ntau li ntawd vim hais tsis yog txhua tus xov tooj yuav tsum yog li distorted. Piv txwv li, "25,13" yuav nyob twj ywm unchanged. Raws li koj twb zaum guessed tus hloov dua siab tshiab yuav muaj kev cuam tshuam tsuas yog cov xov tooj uas, ua ntej los yog tom qab lub point yog cov zauv los ntawm 1 mus rau 12. Nws yog qhov no ntau yog siv los xa mus rau lub hlis ntawm lub xyoo thiab, yog li ntawd, nws yog ntaus nqi raws li ib hnub. Yog hais tias xws tooj yuav poob ib tug los yog ob tug puas, nws yuav qhia nws tus kheej tag nrho cov nyob ib leeg nyob rau hauv lub xam nyob ntev.

hloov point

Muaj ob peb xaiv ntawm yuav ua li cas muab tso rau lub commas nyob rau hauv lub "Eksele". Peb xav txog xwb lub feem ntau yooj yim thiab tswv yim, uas yuav siv tau los ntawm cov neeg siv, tsis hais ntawm cov theem ntawm computer ntaub kawm ntawv.

• Raws li nyob rau hauv "Eksele" hloov lub comma point, siv qhov tsis muaj qhov kev pab cuam? Ua li no, mus rau hauv seem "Tsis" rooj editor thiab mus rau lub "Advanced" ntawv qhia zaub mov. Nyob rau hauv seem no, koj yuav tsum tshem tawm cov daim tshev thawv nyob rau hauv "Siv cov system separators". Yog li txhob xauv lub qhov tom ntej ob lub ntsiab lus, koj yuav tau hloov lub division tias nyob rau hauv yuav tsum tau ua hauj lwm nrog koj cov ntaub ntawv.

• Raws li nyob rau hauv "Eksele" hloov lub comma point, siv lub operating system txoj kev kawm? Nyob rau hauv lub qhov rais Control Vaj Huam Sib Luag yuav tau mus nrhiav lub seem "Regional thiab Language Options." Raws li tus "Format" tab ntawm lub qhov rais uas qhib, hloov mus rau lub submenu "Advanced tej chaw" tab thiab "Numbers" hloov cov zauv feem rau qhov tsim nyog.

• Raws li nyob rau hauv "Eksele" hloov lub comma point siv lub "Nrhiav thiab hloov" muaj nuj nqi? Qhov no zaub mov yog tej zaum paub rau feem ntau cov neeg, thiab nws siv tsis tau ntxiv lus. Lub tsuas taw tes tseem ceeb uas yuav tsum ua yog mus rau ntsiab qhov yuav tsum tau rau pre-editable cheeb tsam. Yog hais tias koj tsis ua lub lag luam no, "Excel" yuav hloov tag nrho ntawm cov muaj cov ntsiab lus rau ntawm daim ntawv thiab xa disparity nyob rau hauv ib feem ntawm lub rooj, koj yuav tau txais nws nyob rau hauv lwm.

Lwm qub tab sis pov thawj txoj kev yog mus ua ntej-hloov separators nyob rau hauv tej yam yooj yim ntawv nyeem editor. Neeg ua hauj lwm "Notepad" los ntawm tus txheej txheem ntawm lub qhov rais cov kev pab cuam yuav paug tiv nrog no ua hauj lwm. Lub mechanism ntawm qhov kev txiav txim yog zoo li lub tau piav txoj kev dag nyob rau hauv tej yam yooj yim hloov ntawm tej yam tshwm sim nyob rau hauv lub hnub ntawm koj spreadsheet editor.

Txawv nyob rau hauv cov zaub mov ntawm chaw ua hauj lwm suites

Nyob rau hauv lub chaw ua hauj lwm suite ntawm Microsoft nrog txhua tshiab version yog sib txawv dog dig arrangement ntawm cov zaub mov cov khoom. Yog tsis muaj kev zam thiab Excel 2013. Nyob rau hauv tas li ntawd mus tsim kev hloov uas tau kov cov xim tswvyim thiab cov tsos ntawm cov icons rau tus xov hais kom ua tau txav tau cov yam khoom "Options". Nws tsiv mus rau hauv qab ntawm lub ntsiab nco-down ntawv qhia zaub mov nyob rau sab ntawm nws ib feem.

Nyob rau hauv tag nrho cov lwm yam neeg siv kev ua nyob rau hauv Excel 2013 siv cov tswv yim nyob rau hauv lub yav dhau los tshooj lus no, yog kiag li analogous mus ua hauj lwm nrog ua ntej lawm versions. Thaum koj qhib tau txav mus rau qhov chaw ntawv qhia zaub mov, koj yuav pom koj tus kheej nyob rau hauv ib tug paub interface.

Mus sum txog, ces tag nrho cov chaw ua hauj lwm versions, muaj xim sib txawv rau txhua tus kev pab cuam kom muaj qhov khoom tsis nyob rau hauv lub sidebar. Cov muaj xws li cov version ntawm 2013 thiab tag nrho cov tom ntej, ntau tshaj kev xaiv.

pitfalls

Tam sim no, to taub raws li nyob rau hauv "Eksele" yog hloov nrog ib tug tsis nco qab taw tes, nrog lub peculiarities ntawm txoj kev piav. Hloov cov operating system chaw los yog kev pab cuam qhov chaw, ntawm chav kawm, muaj peev xwm pab tau nyob rau hauv cov ntaub ntawv ntawm ib tug ib-lub sij hawm yuav tsum tau, tab sis yeej ib txwm nyob rau hauv no hom tsis ua hauj lwm zoo nyob heev.

Ntau npaum li cas preferable los ntawm lub standpoint ntawm practicality zoo ib-lub sij hawm cov ntaub ntawv pauv nyob rau hauv ib yam cheeb tsam los ntawm kev siv cov kev tshawb fawb qhia zaub mov. Nyob rau hauv cov ntaub ntawv no, koj tsis khiav txoj kev pheej hmoo ntawm distortion ntawm lawv cov ntaub ntawv nyob rau hauv lwm yam ntxhuav thiab muaj peev xwm visually tswj tus txheej txheem kev hloov ntawm fractional dividers.

Ntawv hom thiab xam

Tsis tag li ntawd piav, muaj lwm nthuav feature ntawm lub rooj editor "Excel". Cov ntawv nyeem nkag los luam, tej zaum yuav tsis tau pom zoo raws li cov ntaub ntawv nyob rau hauv tej rooj plaub. Cell nyob rau hauv uas lub xov tooj twb khaws cia nyob li ntawv, yuav tsum khij nrog ib tug ntsuab daim duab peb sab nyob rau hauv lub Upper rau sab laug ces kaum. Outwardly, txhua yam zoo dlej, cov nuj nqis yog tsis distorted, tab sis cov ntaub ntawv tsis txhob mus thaum sim mus tsim kev kwv yees ntawm cov ntaub ntawv ntawm xws li ib tug ntawm tes.

Yog li, txoj cai-nrhiav rooj yuav muab lub tsis ncaj ncees lawm lub sij hawm, yog tias koj tuav nws nyob rau hauv lub xam. Qhov teeb meem no yog solved los ntawm kev txhais tau tias "Excel". Xaiv ib tug ntawm tes nrog ib tug ntsuab ces kaum nyob ze ntawm lub supernatant yuav yuav ntes tau cov exclamation mark nyob rau hauv ib tug daj daim duab peb sab. Txhaj rau nws yuav ua rau ib tug me me lub ntsiab lus teb ntawv qhia zaub mov. By xaiv nws cov sab saum toj kev xaiv "Hloov mus tus xov tooj", koj yog tsis muaj cov ntaub ntawv tsis, hloov lawv saib.

Tom qab xws li ib tug straightforward lag luam, tag nrho cov suav yuav tsum tau ua kom raug. Rau kom koj muaj peev xwm xaiv tau ntau tshaj ib tug xws li cell, thiab ob peb uas nyob ib sab thiab tam sim ntawd hloov lawv chaw siv lub ntsiab lus teb ntawv qhia zaub mov.

Nyob rau hauv xaus

Nyob rau hauv no tsab xov xwm peb coj ceev ceev thiab yeej ua hauj lwm txoj kev los kho sawv cev ntawm hauv daim ntawv ntawm cov ntaub ntawv nyob rau hauv "Excel". Lawv daim ntawv thov nyob rau hauv kev xyaum yuav pab tau kom koj qab haus huv thiab lub sij hawm thaum ua hauj lwm nyob rau hauv lub spreadsheet.