How to convert numbers into words in Excel ( Tagalog Tutorial)

Поделиться
HTML-код
  • Опубликовано: 26 окт 2024

Комментарии • 187

  • @ninjacath9182
    @ninjacath9182 3 года назад +1

    sir we really need this kind of tutorial especially ng advanced na lahat sa office o anywhere kailangan marunong kana gumamit ng excel,maraming salamat po dito laking tulong nito

  • @StaMaria492
    @StaMaria492 Год назад +1

    Thank you so Much Mam. sobrang laking tulong po sa excell ko, mas pinabilis trabaho ko. Ty

  • @hardysnight-tsf3667
    @hardysnight-tsf3667 3 года назад +1

    Nays naman nyan galing naman nyan salamat sa tutorial napaka husay naman nyan may natutunan ako dyan salamat sa pag bahagi ng bidyo.

  • @a_romeninja2893
    @a_romeninja2893 3 года назад +1

    Wow.. sawakas na remind ako nito ni ma'am .. thank you Po .nalimutan ko na ito nung high school pa ehh.. more plss

  • @blancheaquino6893
    @blancheaquino6893 3 года назад +2

    Tnx for sharing maam this kind of tutorial lalo na panahon ngayon, kailangan computer literate pra makasabay sa panahon

  • @boibudgetmeal
    @boibudgetmeal 7 месяцев назад

    deserved the like! very helpful. Thank you!

  • @leizlcobarrubias163
    @leizlcobarrubias163 3 месяца назад

    Thank you very much. Very helpful and useful lalo an mag-gawa ng cheke.

  • @girlyluz7100
    @girlyluz7100 3 года назад +1

    Very helpful ng tutorial na ito lalo at madalas akong gumagamit ng excel mas mapapadali ang trabaho ko nito

  • @marygracebaid4892
    @marygracebaid4892 4 месяца назад

    Thanks so much. Very helpful, Ang dali lang sundan.

  • @masterjao1546
    @masterjao1546 Год назад

    Thanks po. Effective yung VBA.

  • @joelakatediezon8891
    @joelakatediezon8891 2 месяца назад +1

    huhuhu bakit kaboses ni mayor alice guo HAHAHAH

  • @JennoTv
    @JennoTv 3 года назад +1

    Nice content lods nakakadugo ng utak....very helpful po ang content nyo po

  • @jessiecrisonia8015
    @jessiecrisonia8015 2 месяца назад

    Maraming salamat po malaking tulong po, God bless po!

  • @shellamaesalise2350
    @shellamaesalise2350 3 года назад +2

    thanks for sharing your ideaas on how to convert numbers into words in excel sir continue to help

  • @beverleyalberca8229
    @beverleyalberca8229 8 месяцев назад

    thank you so much for sharing the peso script

  • @rdpawnshopinclapaz328
    @rdpawnshopinclapaz328 2 месяца назад

    Thankyou so much bigbig help po maam.

  • @JaimeJrJose
    @JaimeJrJose Год назад +1

    it really helps me a lot.. thank you

  • @EduardoCruz-ns2ks
    @EduardoCruz-ns2ks Год назад

    Perfect maam. Thanks a lot.

  • @keiando4290
    @keiando4290 Год назад +1

    Thank you. Very helpful

  • @sittiekdrm9223
    @sittiekdrm9223 Год назад +1

    Thank you for sharing your knowledge.

  • @feyserrano6862
    @feyserrano6862 Год назад +1

    Hello, thank you for this!

  • @carolynlorete-caingcoy9813
    @carolynlorete-caingcoy9813 9 месяцев назад

    So helpful! more vids po

  • @jeanetteburda2790
    @jeanetteburda2790 Год назад

    Thank you so much! You are a blessing to me!

  • @ecamchannel6412
    @ecamchannel6412 3 года назад +1

    Nice tutorial po. Mas malinaw intindihin yung ganito po :)

  • @annisencio
    @annisencio 6 месяцев назад

    hi mam, very simple and direct approach, pwede po makahingi ng script sa peso and dollar, thanks and more videos pa po.

  • @cybergameuniverse7324
    @cybergameuniverse7324 3 года назад +1

    Nako na nosebleed ako pero I so love this

  • @kioraa3704
    @kioraa3704 5 месяцев назад

    thank you so much. kaya lang di ko alam kung paano gumawa ng code. 😊

  • @khanzubairkhan3030
    @khanzubairkhan3030 11 месяцев назад

    Excellent help

  • @markarnelbellon
    @markarnelbellon Год назад

    thank you and God bless

  • @Ninja-jw8yb
    @Ninja-jw8yb 3 года назад +1

    wow ang galing naman po nito kaso di ko alam ito ehh

  • @ihateutoonz1568
    @ihateutoonz1568 3 года назад +1

    Nako kailangan talaga mag aral ng mabuti sa computer tulad nito ang hirap talaga team marj malbago

  • @estelaconstantino-oropeza6548
    @estelaconstantino-oropeza6548 Год назад

    Thank you❤

  • @Angel_Alvarez_Concepcion57
    @Angel_Alvarez_Concepcion57 Год назад

    Excelent ingeniero gracias por su ayuda y abrazos desde Puerto Rico

  • @rjtomacas2966
    @rjtomacas2966 2 года назад

    big help po siya, malinaw pa ang paliwanag at walang paligoy ligoy

    • @vinzk3lion68
      @vinzk3lion68 Год назад

      Napaliwanag po ba kung san galing ung script?

  • @mahonrimadrilejos8588
    @mahonrimadrilejos8588 3 года назад +1

    Wow galing naman idol nakakahilo hahaha

  • @myklopez9843
    @myklopez9843 2 года назад +2

    Sa isang worksheet lang applicable yan...tama po ba....kelangan ulit i copy yung module sa bagong worksheet....di ba pwede naka integrate na sa ms excel...ty

    • @sethrandom2323
      @sethrandom2323 2 года назад +1

      Tama ka sir. Applicable lang sa isang work sheet. After mo i close at pag open mo ulit ng saved excel file mag eerror na sya.

  • @PEARLYCATAYAS
    @PEARLYCATAYAS Год назад +1

    hello po, sobrang laking tulong po nito pero may konti lang po akong napansin ko po sa code ng peso, Cents po ang ginamit instead of "centavos" tapos sana po may "only" pagkatapos ng peso.

    • @engineerlife1016
      @engineerlife1016  Год назад +1

      Email nyo po ako d2 mam masteringmath101@gmail.com para masend ko ung script. Thank you.

    • @bevelynpineda6701
      @bevelynpineda6701 Год назад

      @@engineerlife1016 maam pwede pasend dn po ng script

    • @MeLanie-ot3dj
      @MeLanie-ot3dj Год назад

      Maam pwede pasend po ng script

  • @richardpis-an1844
    @richardpis-an1844 7 месяцев назад

    salamat madam...

  • @mariaoliviabunagcanillas3864
    @mariaoliviabunagcanillas3864 Год назад

    salamat po... :*

  • @donna542
    @donna542 Год назад

    Thank you so much

  • @kuyareystv7438
    @kuyareystv7438 11 месяцев назад

    salamat po

  • @shinichiconan5503
    @shinichiconan5503 Год назад +2

    hello thanks po sa info. tanong lang po paano po kapag ng round off yung decimal,may na encounter po kasi akong ganito example 1.64 tas ang inwords ay 1 peso and sixty-five cents or vice versa 1.65 and inwords naman ay 1 peso and sixty-four cents? salamat po

    • @engineerlife1016
      @engineerlife1016  Год назад

      Pasend po ng email here @masteringmath101@gmail.com. para po ma visualize ko ung problem.. and ano pong code# ung ginamit nyo na script.. salamat po.

  • @aldrinbalasabas6255
    @aldrinbalasabas6255 6 месяцев назад

    Nice content

  • @almatingzon4191
    @almatingzon4191 Год назад +1

    thank you so much for sharing your knowledge.

  • @FranDrei
    @FranDrei Год назад +1

    hello po. pag naclose excel then open and change value error na sya need ulit input formula?

    • @engineerlife1016
      @engineerlife1016  Год назад

      Change nyo po ung file extension name nya sa macro enabled worksheet. May video tutorial din po ako. Part II po ng spellnumber...

  • @coffeeteevee1418
    @coffeeteevee1418 Год назад

    Thank you.. po

  • @esdnewninja3526
    @esdnewninja3526 3 года назад +1

    Very informative video po! From team marj malbago

  • @princesswingco8724
    @princesswingco8724 2 года назад +4

    Hello san po nakukuha yung mga spell number na format?

  • @estherbero1637
    @estherbero1637 2 месяца назад +1

    Hi Maam saan po kocopya ng spell number na value sa notepad?

  • @Rei-hz9lx
    @Rei-hz9lx 3 месяца назад

    Thanks. Paano po kung mahaba ang words at ituloy sa next row?

  • @VielanGaralda
    @VielanGaralda 11 месяцев назад +1

    Hello ung link po na e copy at paste po san po pwedi makuha ung ilalagay sa module

  • @jackyestipona8030
    @jackyestipona8030 Год назад

    Tnx

  • @EgbertAstorga
    @EgbertAstorga 4 месяца назад

    thank you for sharing. done copying code.

  • @michaeljohneria8732
    @michaeljohneria8732 Месяц назад

    sir wala ba nung "& 50/100" ganto kasi kadalasan ginagamit sa checks

  • @marcjhuliusgabriel6168
    @marcjhuliusgabriel6168 Год назад +1

    Goodpm po. Paano po kapag Variable not Defined. Naka highlight po yung nasa taas na Function SpellNumber (ByValMyNumber).
    Ano po kaya ang mali dyan? Thanks po.

    • @engineerlife1016
      @engineerlife1016  Год назад

      Please send me email at masteringmath101@gmail.com po for full details po. thank you.

  • @vicentealferez8125
    @vicentealferez8125 5 месяцев назад

    Hi po paano po nakuha Yong from input kilo to waste and output finish product.

  • @ampbuilders7860
    @ampbuilders7860 Месяц назад

    saan mo po na copy yung VBA? baka un problema kasi hindi sya nag wowork

  • @kennnnnethchua
    @kennnnnethchua Год назад

    Thank you. The script for Peso works. But the one for USD nag error

  • @tokntoonz9028
    @tokntoonz9028 3 года назад +1

    Actually wala akung idea about sa excel format pero automatic po Yung nag change ma'm basta Naka program na Yung excel Tama po ba team marj malbago

  • @mariarosellemercolita2584
    @mariarosellemercolita2584 Год назад +1

    san mo po nakuha yung script sa notepad?

  • @marzpacuma6872
    @marzpacuma6872 3 месяца назад

    hi mam..syntax error po..what shoud I do?

  • @4thss
    @4thss 6 месяцев назад

    Hello po may error na lumalabas pagka paste ko ng code
    only comments may appear after End Sub, End Function, or End Property.
    please Help

  • @iamjuliet7252
    @iamjuliet7252 Год назад

    Pano kumuha ng code . Katulad ng ginwa mo sa check format?

  • @maryhuelva9774
    @maryhuelva9774 Год назад +1

    how to get rid of the cents part?

    • @engineerlife1016
      @engineerlife1016  Год назад

      Send ko po sa inyo mam ung code para sa walang cent... Pls email me at masteringmath101@gmail.com. thank you

  • @jovithbertumen
    @jovithbertumen 13 дней назад

    Hi Mam Saan po ako makakakuha ng copy ng code for VBA spellnumber nag eerror po kasi sakin mam

  • @aicoandaya8015
    @aicoandaya8015 3 года назад +1

    Nag try aq bkit kaya nag automatic round off ung amount in words nya?

    • @engineerlife1016
      @engineerlife1016  3 года назад

      Hello, pwede nyo po isend dito sa email yung result? masteringmath101@gmail.com. Thank you!

    • @aicoandaya8015
      @aicoandaya8015 3 года назад

      @@engineerlife1016 Thank you sa assistance, Nag send na po ako ng email... Warm Regards

  • @goodiesfindsreview1586
    @goodiesfindsreview1586 Год назад +1

    Can you teach us how to save this formula permanently in our excel?

    • @engineerlife1016
      @engineerlife1016  Год назад +1

      I have part 2 of this. Kindly see the description box. Thank you.

    • @goodiesfindsreview1586
      @goodiesfindsreview1586 Год назад +1

      @@engineerlife1016 Hi thank you for the response. I got it and I am already using it. This helps alot and I am thankful for it. Happy New Year and God bless. ❤

    • @asukalroyol5546
      @asukalroyol5546 Год назад +1

      San nakuha ung asa notepad

    • @johnretxedbincay9571
      @johnretxedbincay9571 Год назад

      Pano makuha ang Script?

  • @k_animeclips290
    @k_animeclips290 Год назад +1

    Hi. I would like to convert php 56.24 to Fifty-six and 24/100 pesos paano po

    • @engineerlife1016
      @engineerlife1016  Год назад

      Pls send me email po masteringmath101@gmail.com. thank you.

    • @marzpacuma6872
      @marzpacuma6872 3 месяца назад

      ​@@engineerlife1016hello po..pano po ito ganyan din sa amin..

  • @indorios8208
    @indorios8208 6 месяцев назад

    Hindi po namin kung ano ang entry sa module copy paste lang kasi sa existing file. Sana ma explain mo rin how to make entries sa module

    • @engineerlife1016
      @engineerlife1016  6 месяцев назад

      Ung VBA code po ba? Sa ngayon po kc basic and simple excel techniques lang po ang tinuturo ko for beginners. Soon po mag introduce ako ng basic programming and VBA courses. Medyo complicated lang po sya ituro.

  • @kuysdelrosero4143
    @kuysdelrosero4143 Год назад +1

    Pano gagawin ung nilagay mo sa module?

    • @engineerlife1016
      @engineerlife1016  Год назад

      Ung vba coding po ba? Copy nyo lang po ung nasa files na and2 sa description. Salamat po.

  • @asher_alas
    @asher_alas 8 месяцев назад

    Hello. Can you make this format po 1,254.80 . In words ONE THOUSAND TWO HUNDRED FIFTY-FOUR & 80/100? Yung dulo is 80/100. Salamat.

    • @engineerlife1016
      @engineerlife1016  6 месяцев назад

      try nyo po mam ung ibang script sa description box

  • @gianrellecorrales5799
    @gianrellecorrales5799 10 месяцев назад

    Hi, pwede po pahelp. Pano po ichachange ung cent to fraction tas with only?
    Ex. 18.34
    Eighteen pesos and 34/100 only
    Thanks you so much sa sasagot 😊

  • @rhyanorbeso8966
    @rhyanorbeso8966 17 дней назад

    Saan po yung spell number na program sa module?

  • @PaulinoDuque
    @PaulinoDuque Год назад +1

    San Po kaya pde makakuha ng free script n gaya ng gamit nyo

  • @syrelmilloroso6045
    @syrelmilloroso6045 8 месяцев назад

    Paano po pag ganito gustong format sa centavos "80/100"?

  • @JourneytoEurope01
    @JourneytoEurope01 2 года назад

    Saan mo nakuha yun kinapi mo from notepad

  • @melvinianraeavila-xk5jp
    @melvinianraeavila-xk5jp Год назад

    Paano tanggalin ang cent maam?

  • @melchapoquita1888
    @melchapoquita1888 Год назад +1

    Hi Maam. Thank you for sharing your ideas. I sent an email po sau. Hope you can help me. Thank you so much! God bless your channel!

    • @annalyntorio8227
      @annalyntorio8227 Год назад

      Let me check po ma'am. Thank you po sa support sa channel ko. Godbless po.

  • @retchelrom3418
    @retchelrom3418 Год назад

    Hello po, how to create script in the notepad?

  • @alfredborje9953
    @alfredborje9953 5 месяцев назад

    Paano po gunawa nung module/script madam?

  • @janiceaarivera6066
    @janiceaarivera6066 Год назад

    San po nakuha mam Yung format ?Yung code ng spell number po?

  • @kimairagache4056
    @kimairagache4056 8 месяцев назад

    Pano po pag di nalabas sa alt+f11?

  • @dionalyncornejo3384
    @dionalyncornejo3384 Год назад

    good morning po bkt po hindi ko maiapply?pasencya n po kulang po ang aking kaalaman p tlaga regarding po s mga ganito.bka nmn po pd magpatulong.tnx po and more power.

    • @engineerlife1016
      @engineerlife1016  Год назад

      pwede nyo po ako ma contact sa email ko. masteringmath101@gmail.com. salamat po.

  • @veronicalaborte773
    @veronicalaborte773 Год назад +1

    Hi ma'am pede po ako makahingi ng script number to word in peso thank you

  • @denverpili3510
    @denverpili3510 Год назад

    Ang tanong!! Paano gumawa ng function or calculation sa excel to convert number to words in your own , no vba, no external program. Just pure excel.

    • @engineerlife1016
      @engineerlife1016  6 месяцев назад

      may gumawa na po nito. mahaba lang po ang formula nila.

    • @denverpili3510
      @denverpili3510 Месяц назад

      @@engineerlife1016 nung wala pang ms365 nakagawa na ako nung mahabang yun, but today using LET AND LAMBDA(& convert to names), we can customized our own formula, so easy and mas maiksi.

  • @markrafaela3241
    @markrafaela3241 Год назад

    Hi pano kaya pag ng #name?
    Example: 413,000.00
    Four hundred thirteen thousand pesos only.
    Every time kasi na iclose na pagmag input nako ng #name?.
    Thank you

    • @engineerlife1016
      @engineerlife1016  Год назад

      Mam pa send po d2 sa email ko ng error. masteringmath101@gmail.com. tingnan ko po if kya natin ma solve. thank you.

  • @jesssolares6539
    @jesssolares6539 10 дней назад

    Pakopya ng spell number sa notepad na paste nyo sa module

  • @Vipsv101
    @Vipsv101 2 года назад

    San niyo po kinuha ang formula?

  • @PowergearInc
    @PowergearInc Год назад

    WALANG Lumalabas pag alt+f11 baka may ibang option?

    • @engineerlife1016
      @engineerlife1016  Год назад

      Ano po ginagamit nyo na spreadsheet? Microsoft office po ba? Possible po na hindi sya applicable sa ibang spreadsheet like google sheets.

  • @RonellCana-rr8tt
    @RonellCana-rr8tt Год назад +1

    Paano po nag syntax error

    • @engineerlife1016
      @engineerlife1016  Год назад

      Paano pong syntax error sir. Pasend po d2 sa email ko kung ano po na encounter nyo na problem masteringmath101@gmail.com. thank you po.

  • @ReneekimReyes
    @ReneekimReyes 2 месяца назад

    Wat if po kung ganito Sana forma " one hundred twenty one pesos and 10/100 only..

  • @enabayangan962
    @enabayangan962 Год назад

    saan mo nakuha ung data sa notepad?

  • @shellyannebautista3429
    @shellyannebautista3429 Год назад

    saan po kayo nakakakuha ng script?

  • @dhangsquitaleg
    @dhangsquitaleg 5 месяцев назад

    Alt+f11 doesn't work sa pc ko

  • @jxnb1990
    @jxnb1990 3 месяца назад

    my error po ung akin pano po ito?

  • @phengtorres3185
    @phengtorres3185 8 месяцев назад

    San po pwede mag copy ng spell number na format?

  • @marlongevero3780
    @marlongevero3780 2 года назад

    Pwd po maka hingi ng details ng iyong note pad?
    Thank uou po

  • @boymalinao963
    @boymalinao963 Год назад

    Hello paano gumawa nang script para ma e paste?ko

  • @mabeltapel
    @mabeltapel 7 месяцев назад

    how to remove the "no cents" word?

    • @engineerlife1016
      @engineerlife1016  6 месяцев назад

      meron po ako script na walang “no cents” nasa description box po.

  • @jefersonkaragdag3693
    @jefersonkaragdag3693 Год назад +1

    ano other function sa module code, sakin kasi di nag work ung alt F11

    • @engineerlife1016
      @engineerlife1016  Год назад

      File > Options > Customize Ribbon> Popular commands> Add Developer or tick the developer.
      Ma activate ung developer tab. At makikita nyo po ung visual basic.