gayanwin

Well-known member
  • Jan 4, 2009
    2,571
    383
    83
    Kurunegala
    MAchan Excel gana wada karayek nadda machan. podi deyak dana ganna one.
    kohomada machan excel wala Auto decimal place wen wenna hadanne kiyala diyanko
     

    BlueBat

    Member
    Aug 14, 2011
    15,181
    1,092
    0
    Click the File tab and then click Excel Options
    Click the Advanced tab.
    Select the Automatically Insert a Decimal Point check box in the Editing Options section.

    TBIAW74.jpg


    Click OK
     

    BlueBat

    Member
    Aug 14, 2011
    15,181
    1,092
    0
    Machan office 2007 thiyenne. excel option koheda thiyenne hoyanna baha ban

    Click the Office Button and then click the Excel Options button
    Click the Advanced tab
    Select the Automatically Insert a Decimal Point check box in the Editing Options section.

    hcJrAWS.jpg


    Click OK
     

    gayanwin

    Well-known member
  • Jan 4, 2009
    2,571
    383
    83
    Kurunegala
    Click the Office Button and then click the Excel Options button
    Click the Advanced tab
    Select the Automatically Insert a Decimal Point check box in the Editing Options section.

    hcJrAWS.jpg


    Click OK

    uba excel gana godak danna kenek nam mata hoyala diyanko, Naththam hadala diyanko menna me wage ekak.

    lankawe thiyana banks wala checqu wala bank code ekai branc code ekai gahuwama, Bank ekai branch ekai check number ekai auto watila amount cheque amount eka enter karana puluwan widiye podi excel wada kallak. ita passe hawasata report eka print aragena total eka balaganna puluwan widiye