Cov txheej txheem:

Kuv yuav tshem cov dashes li cas?
Kuv yuav tshem cov dashes li cas?

Video: Kuv yuav tshem cov dashes li cas?

Video: Kuv yuav tshem cov dashes li cas?
Video: Npauj Kub Xyooj/Koj Yuav Kuv Txhaws Kev Chim (Official MV 2023) new song 2024, Hlis ntuj nqeg
Anonim

Hom a dash nyob rau hauv lub "Nrhiav dab tsi" box. Cia lub thawv "Hloov Nrog" khoob. Nyem qhov "Hloov tag nrho" khawm. Excel yuav pom tag nrho cov dashes nyob rau hauv cov cell xaiv thiab tshem tawm lawv.

Tsuas yog li ntawd, kuv yuav ua li cas thiaj li tshem tawm cov ntawv dashes ntawm kuv tus lej Xaus Saus?

Tshem tag nrho cov dashes ntawm SSN nrog Hloov feature

  1. Xaiv cov SSN hlwb uas koj yuav tshem tawm dashes los ntawm, thiab nias Ctrl + H yuam sij ua ke qhib qhov Nrhiav thiab Hloov dialog.
  2. Nyob rau hauv Nrhiav thiab Hloov dialog, ntaus dashes - mus rau hauv Nrhiav dab tsi lub thawv, ntaus tsis muaj dab tsi rau hauv Hloov nrog lub thawv, thiab tom qab ntawd nyem lub pob Hloov Tag nrho.

Tom qab ntawd, lo lus nug yog, yuav ua li cas ntxiv ib hyphen hauv Excel cell?

  1. Nyem thiab luag koj tus cursor hla ntau lub hlwb uas koj xav kom sib npaug ntxiv hyphens.
  2. Txoj cai-nias qhov kev xaiv thiab nyem "Format Cells." Lub qhov rai Format Cells dialog qhib.
  3. Nyem qhov "Numbers" tab nyob rau sab saum toj ntawm Format Cells dialog box.
  4. Nyem "Custom" nyob rau hauv qab ntawm cov npe qeb.

Kuj Paub, Kuv yuav hloov cov dashes rau SSN hauv Excel li cas?

Thiab nyob rau hauv Format Cells dialog box, nyob rau hauv tus lej tab, nyem Tshwj xeeb los ntawm qeb pane, thiab tom qab ntawd nyem Social Security Tus nab npawb hauv qab hom npe lub thawv. 4. Ces nyem OK kaw no dialog, thiab koj cov lej tau ntxiv rau dashes nyob rau hauv thawj cell ntau ib zaug.

Yuav ua li cas koj ntxig ib dash hauv Excel?

Rau ntxig ib en- dash hauv koj daim ntawv, tuav lub Alt key thiab hom 0150 ntawm tus lej keypad; ib em- dash yog tsim los ntawm tuav tus yuam sij Alt thiab ntaus 0151. (Nco ntsoov koj hom tus lej ntawm tus lej keypad. Yog koj hom lawv siv lwm tus lej yuam sij, nws yuav tsis ua haujlwm.)

Pom zoo: