Yuav Ua Li Cas Tshem Tus Thawj Coj lossis Tom Qab Zeros hauv Excel: 12 Cov Kauj Ruam

Cov txheej txheem:

Yuav Ua Li Cas Tshem Tus Thawj Coj lossis Tom Qab Zeros hauv Excel: 12 Cov Kauj Ruam
Yuav Ua Li Cas Tshem Tus Thawj Coj lossis Tom Qab Zeros hauv Excel: 12 Cov Kauj Ruam

Video: Yuav Ua Li Cas Tshem Tus Thawj Coj lossis Tom Qab Zeros hauv Excel: 12 Cov Kauj Ruam

Video: Yuav Ua Li Cas Tshem Tus Thawj Coj lossis Tom Qab Zeros hauv Excel: 12 Cov Kauj Ruam
Video: TUDev Tech Talk с профессором Борой Озкан - Финтех и будущее финансов 2024, Tej zaum
Anonim

Qhov wikiHow qhia koj li cas kom tshem cov zeros los ntawm qhov pib (Ua) lossis xaus (Trailing) ntawm cov lej hauv Excel.

Cov kauj ruam

Txoj Kev 1 ntawm 2: Tshem Tus Thawj Zeros

Kauj Ruam 1. Tshaj tawm cov xov tooj nrog ua zeros

Yog tias koj ua haujlwm nrog tus lej hauv kab, koj tuaj yeem hais meej tag nrho kab ntawv los ntawm txhaj kab ntawv.

Tshem Tawm Kev Ua lossis Trailing Zeros hauv Excel Kauj Ruam 2
Tshem Tawm Kev Ua lossis Trailing Zeros hauv Excel Kauj Ruam 2

Kauj Ruam 2. Txoj cai-nias ntawm cov xov tooj tseem ceeb

Yog tias koj lub khoos phis tawj tsis muaj lub pob nyem sab xis, nyem Ctrl thaum koj nyem nrog sab laug. Cov ntawv qhia zaub mov yuav tshwm.

Tshem Tawm Ua lossis Trailing Zeros hauv Excel Kauj Ruam 3
Tshem Tawm Ua lossis Trailing Zeros hauv Excel Kauj Ruam 3

Kauj Ruam 3. Nyem Format Cells

Lub Format Cells dialog yuav tshwm.

Tshem Tawm Ua lossis Trailing Zeros hauv Excel Kauj Ruam 4
Tshem Tawm Ua lossis Trailing Zeros hauv Excel Kauj Ruam 4

Kauj Ruam 4. Xaiv Tus Zauv los ntawm kab sab laug

Tshem Tawm Ua lossis Trailing Zeros hauv Excel Kauj Ruam 5
Tshem Tawm Ua lossis Trailing Zeros hauv Excel Kauj Ruam 5

Kauj Ruam 5. Ntaus tus “0” (xoom) rau hauv “Qhov Chaw Zaum Kawg” lub thawv

Tshem Tawm Ua lossis Trailing Zeros hauv Excel Kauj Ruam 6
Tshem Tawm Ua lossis Trailing Zeros hauv Excel Kauj Ruam 6

Kauj Ruam 6. Nyem OK

Nws yog nyob rau hauv qab txoj cai kaum ntawm qhov screen. Qhov no coj koj rov qab mus rau koj daim ntawv teev npe, qhov uas koj yuav tsum tsis txhob pom zeros ua ntej koj tus lej.

Yog tias koj tseem pom tus lej zeros, ob-nias lub cell, tom qab ntawd nias ↵ Enter lossis ⏎ Return

Txoj Kev 2 ntawm 2: Tshem Tawm Zaum Zero

Tshem Tawm Ua lossis Trailing Zeros hauv Excel Kauj Ruam 7
Tshem Tawm Ua lossis Trailing Zeros hauv Excel Kauj Ruam 7

Kauj Ruam 1. Ua kom pom cov hlwb nrog tus zero tom qab

Yog tias koj tab tom ua haujlwm nrog tus lej hauv kab, koj tuaj yeem hais meej tag nrho kab ntawv los ntawm txhaj kab ntawv.

Tshem Tawm Ua lossis Trailing Zeros hauv Excel Kauj Ruam 8
Tshem Tawm Ua lossis Trailing Zeros hauv Excel Kauj Ruam 8

Kauj Ruam 2. Txoj cai-nias ntawm cov xov tooj uas tau hais tseg

Yog tias koj lub khoos phis tawj tsis muaj lub pob nyem sab xis, nyem Ctrl thaum koj nyem nrog sab laug. Cov ntawv qhia zaub mov yuav tshwm.

Tshem Tawm Ua lossis Trailing Zeros hauv Excel Kauj Ruam 9
Tshem Tawm Ua lossis Trailing Zeros hauv Excel Kauj Ruam 9

Kauj Ruam 3. Nyem Format Cells

Lub Format Cells dialog yuav tshwm.

Tshem Tawm Ua lossis Trailing Zeros hauv Excel Kauj Ruam 10
Tshem Tawm Ua lossis Trailing Zeros hauv Excel Kauj Ruam 10

Kauj Ruam 4. Xaiv Kev Cai los ntawm kab sab laug

Tshem Tawm Ua lossis Trailing Zeros hauv Excel Kauj Ruam 11
Tshem Tawm Ua lossis Trailing Zeros hauv Excel Kauj Ruam 11

Kauj Ruam 5. Ntaus tus lej rau hauv lub npov hauv qab "Hom

Yog tias muaj cov ntawv nyob hauv lub thawv, rho tawm tam sim no. Tom qab ntawd, ntaus 0. ### rau hauv lub thawv.

Tshem Tawm Ua lossis Trailing Zeros hauv Excel Kauj Ruam 12
Tshem Tawm Ua lossis Trailing Zeros hauv Excel Kauj Ruam 12

Kauj Ruam 6. Nyem OK

Koj yuav tsis pom tus lej xoom txawv ntawm qhov kawg ntawm koj tus lej.

Q&A Zej Zog

Tshawb Nrhiav Ntxiv Lus Nug Nug Cov Lus Nug 200 cim sab laug suav nrog koj tus email chaw nyob kom tau txais lus thaum lo lus nug no tau teb. Xa

Pom zoo: