Contents
Idan an saita tsarin rubutu don kowane sel akan takardar (mai amfani ko shirin na iya yin hakan yayin loda bayanai zuwa Excel), to lambobin da aka shigar daga baya cikin waɗannan sel Excel sun fara la'akari da rubutu. Wasu lokuta ana yiwa irin waɗannan sel alama da alamar kore, wanda da alama kun taɓa gani:
Kuma wani lokacin irin wannan alamar ba ya bayyana (wanda ya fi muni).
Gabaɗaya, bayyanar lambobi-as-rubutu a cikin bayananku yawanci yana haifar da sakamako mara kyau da yawa:
- rarrabuwa yana tsayawa aiki akai-akai - "lambobin ƙididdiga" ana matse su, kuma ba a tsara su cikin tsari kamar yadda ake tsammani:
- nau'in ayyuka VLOOKUP (VLOOKUP) kar a sami ma'aunin da ake buƙata, domin a gare su lamba da lamba ɗaya-kamar yadda rubutu ya bambanta:
- lokacin tacewa, ana zaban lambobi masu ƙima cikin kuskure
- sauran ayyukan Excel da yawa kuma sun daina aiki da kyau:
- da dai sauransu.
Yana da ban dariya musamman cewa sha'awar dabi'a don kawai canza tsarin tantanin halitta zuwa lambobi ba ya taimaka. Wadancan. kun zaɓi sel, danna dama akan su, zaɓi Tsarin salula (Tsarin Kwayoyin), canza tsarin zuwa Lambobi (lamba), matsi OK - kuma babu abin da ya faru! Kwata-kwata!
Wataƙila, "wannan ba bugu ba ne, amma fasali", ba shakka, amma wannan ba ya sauƙaƙa mana. Don haka bari mu kalli hanyoyi da yawa don gyara lamarin - ɗayansu tabbas zai taimake ku.
Hanyar 1. Green nuna alama kusurwa
Idan ka ga kusurwar alamar kore akan tantanin halitta mai lamba a tsarin rubutu, to ka ɗauki kanka mai sa'a. Kuna iya zaɓar duk ƙwayoyin da ke da bayanai kawai kuma danna kan alamar rawaya mai faɗowa tare da alamar tsawa, sannan zaɓi umarnin. Juya zuwa Lamba (Maida zuwa lamba):
Duk lambobin da ke cikin kewayon da aka zaɓa za a canza su zuwa cikakkun lambobi.
Idan babu koren sasanninta kwata-kwata, to duba idan an kashe su a cikin saitunan Excel (Fayil - Zaɓuɓɓuka - Tsara-tsara - Lambobi waɗanda aka tsara azaman rubutu ko wanda ridda ta gabace ta).
Hanyar 2: Sake shigarwa
Idan babu sel da yawa, to zaku iya canza tsarin su zuwa lamba, sannan ku sake shigar da bayanan ta yadda canjin tsarin ya yi tasiri. Hanya mafi sauƙi don yin haka ita ce ta tsayawa akan tantanin halitta da danna maɓalli a jere F2 (shigar da yanayin gyara, tantanin halitta yana fara siginan ƙyalli) sannan Shigar. Hakanan maimakon F2 zaka iya danna sau biyu akan tantanin halitta tare da maɓallin linzamin kwamfuta na hagu.
Ya tafi ba tare da faɗi cewa idan akwai sel da yawa, to wannan hanya, ba shakka, ba za ta yi aiki ba.
Hanyar 3. Formula
Kuna iya sauri canza lambobi-pseudo-lambobi zuwa na yau da kullun idan kun yi ƙarin shafi tare da dabarar farko kusa da bayanan:
Rage sau biyu, a wannan yanayin, yana nufin, a zahiri, ninka ta -1 sau biyu. Rage da ragi zai ba da ƙari kuma ƙimar da ke cikin tantanin halitta ba zai canza ba, amma ainihin aiwatar da aikin lissafi yana canza tsarin bayanai zuwa na lamba da muke buƙata.
Tabbas, maimakon ninka ta 1, zaku iya amfani da duk wani aiki na lissafi mara lahani: raba ta 1 ko ƙara da ragi sifili. Tasirin zai kasance iri ɗaya.
Hanyar 4: Manna Musamman
An yi amfani da wannan hanyar a cikin tsoffin juzu'in Excel, lokacin manajoji masu tasiri na zamani sun tafi ƙarƙashin teburin babu wani kusurwa mai nuna kore tukuna bisa manufa (ya bayyana ne kawai a cikin 2003). Algorithm shine:
- shigar da 1 a kowane tantanin halitta mara komai
- kwafi shi
- zaɓi sel masu lambobi a tsarin rubutu kuma canza tsarin su zuwa lamba (babu abin da zai faru)
- danna dama akan sel tare da lambobi masu ƙima kuma zaɓi umarni Manna na musamman (Mana Musamman) ko amfani da gajeriyar hanyar keyboard Ctrl + Alt + V
- a cikin taga da yake buɗewa, zaɓi zaɓi Da dabi'u (Dabi'u) и Haɓaka (Nuni)
A gaskiya ma, muna yin abu ɗaya kamar yadda a cikin hanyar da ta gabata - ninka abubuwan da ke cikin sel ta ɗaya - amma ba tare da tsari ba, amma kai tsaye daga buffer.
Hanyar 5. Rubutu ta ginshiƙai
Idan kuma an rubuta pseudonumbers ɗin da za a canza tare da ƙima ko dubunnan masu rarraba ba daidai ba, ana iya amfani da wata hanya. Zaɓi kewayon tushen tare da bayanai kuma danna maɓallin Rubutu ta ginshiƙai (Rubutu zuwa ginshiƙai) tab data (Kwanan wata). A gaskiya ma, an tsara wannan kayan aiki don rarraba rubutu mai maƙalli zuwa ginshiƙai, amma, a wannan yanayin, muna amfani da shi don wata manufa daban.
Tsallake matakai biyu na farko ta danna maballin Next (Na gaba), kuma a na uku, yi amfani da maɓallin Ƙari (Advanced). Akwatin maganganu zai buɗe inda za ku iya saita haruffan masu rarraba a halin yanzu da ke cikin rubutun mu:
Bayan danna kan Gama Excel zai canza rubutun mu zuwa lambobin al'ada.
Hanyar 6. Macro
Idan dole ne ku yi irin waɗannan canje-canje sau da yawa, to yana da ma'ana don sarrafa wannan tsari tare da macro mai sauƙi. Latsa Alt+F11 ko bude shafin developer (Mai haɓakawa) Kuma danna Kayayyakin aikin Basic. A cikin taga editan da ya bayyana, ƙara sabon tsari ta cikin menu Saka - Module sannan ka kwafi wannan code din can:
Sub Convert_Text_to_Numbers() Selection.NumberFormat = "General" Selection.Value = Selection.Value End Sub
Yanzu bayan zaɓar kewayon, koyaushe kuna iya buɗe shafin Developer - Macros (Developer - Macros), zaɓi macronmu a cikin jerin, danna maɓallin Run (Gudu) – kuma nan take jujjuya lambobi masu ƙima zuwa cikakkun bayanai.
Hakanan zaka iya ƙara wannan macro zuwa littafin macro naka don amfani daga baya a kowane fayil.
PS
Haka labarin ya faru da kwanakin. Wasu kwanakin kuma ƙila a iya gane su ta Excel azaman rubutu, don haka haɗawa da rarrabawa ba za su yi aiki ba. Maganganun sun kasance iri ɗaya da na lambobi, kawai tsarin dole ne a maye gurbinsu da lokacin kwanan wata maimakon lamba.
- Rarraba rubutun m zuwa ginshiƙai
- Lissafi ba tare da dabara ta manna na musamman ba
- Maida rubutu zuwa lambobi tare da ƙari na PLEX