Yadda ake Amfani da Tsarin Lambobin Lissafi a cikin Microsoft Excel
Idan kuna amfani da Microsoft Excel don dalilai na lissafin kuɗi, kuna iya amfani da tsarin lambar lissafin don lambobinku. Akwai hanyoyi da yawa don amfani da wannan daidaitawa Kuma za mu yi bayanin yadda.
Menene tsarin lambar lissafin kuɗi?
A kallon farko, tsarin lambar lissafin yana kama da tsarin kuɗi. Duk da haka, akwai wasu bambance-bambance tsakanin su biyun.
Waɗannan bambance-bambancen su ne:
- alamar kudin : Tsarin lambar lissafin yana sanya alamar kuɗi a hannun hagu mai nisa na tantanin halitta.
- Sifili A matsayin dashes: Ana nuna sifilin ku azaman dashes a wannan tsarin lamba.
- Korau a cikin baka : yana nunawa Lambobi mara kyau
()tsakanin madogara. Excel baya yin wannan ta tsohuwa.
Duk hanyoyin da ke ƙasa suna ba ku damar yin amfani da tsarin lambar lissafi iri ɗaya zuwa lambobinku, don haka yi amfani da duk hanyar da kuka sami mafi sauƙi don yin.
Aiwatar da tsarin lissafin lambar tare da zaɓin kintinkiri
Excel yana da zaɓi a cikin ribbon ɗin sa don taimaka muku yin amfani da tsarin lambar lissafin da sauri a cikin maƙunsar ku.
Don amfani da shi, da farko, buɗe maƙunsar bayanai tare da Microsoft Excel. A cikin maƙunsar bayanai, zaɓi sel waɗanda ke ɗauke da lambobin da kuke son canzawa zuwa lambobin lissafin kuɗi.
في Bar Excel a saman Danna kan Shafin Gida.
A kan Home shafin, a cikin Number sashe, danna ƙasa icon kusa da Accounting Number Format zaɓi.
A cikin menu da ke buɗewa, zaɓi kuɗin don lambobin ku.
Kuma lambobin da kuka zaɓa yanzu suna amfani da tsarin lambar lissafin kuɗi.
Kun shirya.
Aiwatar da tsarin lambar lissafin ta hanyar menu na zazzagewa
Wata hanyar da za a yi amfani da tsarin lambar lissafin kuɗi ita ce yin amfani da jerin abubuwan da aka saukar da lambar.
Don amfani da wannan hanyar, buɗe maƙunsar bayanai tare da Microsoft Excel. Sannan zaɓi sel waɗanda ke da lambobi a cikinsu.
A cikin ribbon na Excel a saman, danna Home tab.
A cikin Home tab, a cikin sashin lamba, danna kan menu mai saukewa.
Daga menu mai saukewa, zaɓi Accounting.
Duk lambobin da kuka zaɓa yanzu suna cikin tsarin lambar lissafin kuɗi.
Wannan shine.
Yi amfani da lambobin lissafi tare da taga Tsarin Sel
Hanya na uku don amfani da tsarin lambar lissafin kuɗi a cikin Excel shine buɗe taga Format Cells.
Don yin wannan, buɗe maƙunsar bayanai kuma zaɓi sel masu lambobi a cikinsu. Dama danna ɗaya daga cikin waɗannan sel kuma zaɓi Tsara Kwayoyin daga menu.
Tagan Format Cells zai buɗe. Anan, daga menu na rukuni a hagu, zaɓi Accounting.
a bangaren dama, Ƙayyade maki goma na lambobin ku Amfani da zaɓin "wuri na goma". sannan Zaɓi kuɗi Daga menu mai saukewa "Symbol".
A ƙarshe, danna Ok a kasan taga.
Kwayoyin da kuka zaɓa yanzu an tsara su a cikin tsarin lambar lissafin.
Yanzu kun shirya don ayyukan lissafin ku a cikin maƙunsar bayanai na Excel.
Shin Excel yana cire sifilin daga farkon lambobin ku? Akwai hanya Don sanya shi kiyaye wadannan sifilai .
