Sauya Saƙo zuwa Lissafi Tare da Musamman Musamman Musamman

01 na 04

Sauya Bayanan da aka shigo daga Rubutun zuwa Lambar Format

Wani lokaci, idan ana fitar da dabi'un ko a kwafe su a cikin takardar aiki na Excel waɗannan dabi'u sun ƙare kamar rubutu maimakon ƙididdiga.

Wannan halin zai iya haifar da matsala idan an yi ƙoƙari don warware bayanai ko kuma idan an yi amfani da bayanan a cikin lissafi da ke haɗa wasu ayyukan ayyukan na Excel.

A cikin hoton da ke sama, alal misali, an saita SUM aikin don ƙara abubuwa uku - 23, 45, da 78 - suna cikin sel D1 zuwa D3.

Maimakon dawowa 146 a matsayin amsar; duk da haka, aikin ya dawo zero saboda anyi amfani da dabi'u guda uku a matsayin rubutu maimakon bayanan lambar.

Halin Hanya

Shirye-shiryen tsoho na Excel don daban- daban na bayanan bayanai sau ɗaya ne wanda ya nuna lokacin da aka shigo da bayanai ko shigar da kuskure.

Ta hanyar tsoho, bayanan lambobi, da maɓallin tsari da sakamakon aiki, ana haɗa su a gefen dama na tantanin halitta, yayin da ma'aunin rubutu suna haɗuwa a hagu.

Lambobi uku - 23, 45, da 78 - a cikin hoton da ke sama suna haɗin kai a gefen hagu na kwayoyin su saboda sune sunaye a yayin da aikin SUM ya haifar da tantanin halitta D4 a hagu.

Bugu da ƙari, Excel zai nuna matsala tare da abinda ke ciki na tantanin halitta ta hanyar nuna wani ƙananan tafarnon kore a cikin kusurwar hagu na tantanin halitta.

A wannan yanayin, tauraren kore yana nuna cewa dabi'u a cikin sel D1 zuwa D3 an shigar da shi azaman rubutu.

Daidaita Bayanan Matsala tare da Manna Musamman

Zaɓuɓɓuka don sauya wannan bayanan zuwa tsarin tsarin shine don amfani da aikin VALUE a Excel da manna na musamman.

Ƙasar na musamman shi ne fassarar fasali na umarnin manna wanda ya ba ka dama da zaɓuɓɓuka game da abin da aka canjawa tsakanin sel a yayin aikin kwafi / manna .

Waɗannan zaɓuɓɓuka sun haɗa da ayyuka na ilmin lissafi na asali kamar ƙari da ƙaddarawa.

Ƙidaya Ƙididdiga ta 1 tare da Manna Musamman

Zaɓin ƙaddamarwa a cikin ƙananan ƙila ba zai ninka dukkan lambobi ba ne kawai ta hanyar adadin kuɗi kuma kunsa amsar a cikin makiyaya, amma zai sake canza dabi'un rubutu zuwa lambar ƙidayar lokacin da aka shigar da kowane shigarwa ta darajar 1.

Misali a shafi na gaba yana amfani da wannan fasalin fasali na musamman tare da sakamakon aikin shine:

• amsar da SUM aiki ya sauya daga zero zuwa 146
• nauyin uku sun canza canje-canje daga gefen hagu na cell zuwa dama
• maƙunsar kore ta nuna alamar kuskure daga kwayoyin dake dauke da bayanai

02 na 04

Ƙara Misali Misali: Karɓar Rubutu zuwa Lissafi

Domin ya canza dabi'un rubutu zuwa lambar data, muna buƙatar farko mu shigar da lambobi kamar rubutu.

Anyi wannan ta hanyar rubuta wani ɓangaren ( ' ) a gaban kowace lambar yayin da aka shiga cikin tantanin halitta.

1. Bude sabon takardun aiki a cikin Excel wanda ke da dukkan kwayoyin da aka saita zuwa Tsarin Janar
2. Danna kan tantanin halitta D1 don sa shi tantanin halitta mai aiki
3. Rubuta apostrophe mai lamba 23 cikin cell
4. Latsa maɓallin shigarwa a kan keyboard
5. Kamar yadda aka nuna a cikin hoton da ke sama, cell D1 ya kamata a sami triangle kore a cikin kusurwar hagu na tantanin halitta kuma lambar ta 23 ya kamata a haɗa shi a gefen dama. Babu kuskure a cikin tantanin halitta
6. Danna kan tantanin halitta D2, idan ya cancanta
7. Rubuta mai ridda da lambar 45 ta shiga cikin tantanin halitta
8. Latsa maɓallin shigarwa a kan keyboard
9. Danna kan tantanin D3
10. Rubuta mai ridda wanda lambar 78 ta biyo cikin tantanin halitta
11. Latsa maɓallin shigarwa a kan keyboard
12. Danna kan tantanin halitta E1
13. Rubuta lambar 1 (babu mai ridda) a tantanin salula kuma latsa maɓallin shigarwa akan keyboard
14. Lambar 1 ya kamata a haɗa ta a gefen dama na tantanin halitta, kamar yadda aka nuna a cikin hoto a sama

Lura: Domin ganin gajerun gaban gaban lambobin da aka shiga cikin D1 zuwa D3, danna kan ɗaya daga cikin waɗannan kwayoyin, kamar D3. A cikin maɓallin tsari a sama da takardun aiki, shigarwa '78 ya zama bayyane.

03 na 04

Ƙara Misali Misali: Sauya Rubutu zuwa Lambobi (Ci gaba).

Shigar da SUM Function

1. Danna kan tantanin D4
2. Rubuta = SUM (D1: D3)
3. Latsa maɓallin shigarwa a kan keyboard
4. Amsar 0 ya kamata ya bayyana a cell D4, tun da an sanya dabi'u a cikin sel D1 zuwa D3 a matsayin rubutu

Lura: Bugu da ƙari, bugawa, hanyoyin da za a shigar da aikin SUM a cikin wani ɗigon ayyukan aiki sun hada da:

• Maɓallan gajeren hanya
• SUM aiki akwatin maganganu
• AutoSum

Kashe Saƙo zuwa Lissafi tare da Manyan Musamman

1. Danna tantanin halitta E1 don sa shi tantanin halitta mai aiki
2. A Kan shafin shafin rijistar , danna kan Copy icon
3. Wajibi ne ya kamata ya bayyana a cikin sel E1 yana nuna cewa an kwashe abubuwan da ke ciki na wannan tantanin halitta
4. Sanya sassa D1 zuwa D3
5. Danna maɓallin da ke ƙasa a ƙarƙashin gunkin Manna a kan shafin shafin rubutun don buɗe menu na saukewa
6. A cikin menu, danna Manna Musamman don buɗe maɓallin maganin Paste na musamman
7. A karkashin Sashin aiki na akwatin maganganu, danna maɓallin rediyo kusa da Multiply don kunna wannan aiki
8. Danna Ya yi don rufe akwatin maganganu kuma komawa zuwa aikin aiki

04 04

Ƙara Misali Misali: Sauya Rubutu zuwa Lambobi (Ci gaba).

Sakamakon Ayyukan aiki

Kamar yadda aka nuna a hoton da ke sama, sakamakon wannan aiki a cikin takardun aiki ya kamata:

• halayen uku a cikin sel D1 zuwa D3 ya kamata a haɗa su da dama a cikin kwayoyin jikinsu
• Ya kamata a cire matakai mai kore daga saman kusurwar dama na kowace tantanin halitta
• Sakamakon aikin SUM a cikin cell D4 ya kamata a karanta yanzu 146 wanda shine jimlar lambobi uku a cikin kwayoyin D1 zuwa D3