Posts

Showing posts with the label excel

Calculate age from Date of Birth

Image
 

Make diagonal border in excel

Extract financial year from dates

Break password EXCEL SHEETS

Image
 

EASILY UNLOCK Protected Excel Sheets WITHOUT Password

Image

Nepali Functions Addin for Excel V6

Image
http://sajanmaharjan.com.np/my-works/nepali-functions-addin-for-excel/ It has been sometime that people had been requesting for an excel utility that would perform the date conversion from AD to BS and vice versa in Excel itself. Finally, I have had the time to program it and hope that it can help you in some way. You can download the file here. DOWNLOAD SAJAN.NEPALI.FUNCTIONS.V6.XLAM Available Functions Example Description AD2BS( “enter_ad_date” ) AD2BS( "12/25/2016") AD date format ( MM/DD/YYYY ) BS2AD( “enter_bs_date” ) BS2AD( "2073/12/25") BS date format ( YYYY/MM/DD ) number2words( enter_number ) number2words( 123 ) Returns the result in preeti font number2words_preeti( enter_number, show_units ) number2words_preeti( 123 ) Returns the result in preeti font. Here show_units is optional and set to false by default; Shows paisa count if set to true. number2words_unicode( enter_number, show_units ) number2words_unicode( 123 ) Returns the result i...