Nepali Functions Addin for Excel consists of various functions that help nepali excel users to perform tasks easily. The list of available functions are listed below:
- AD2BS ("enter_ad_date") // AD date format (MM/DD/YYYY)
- BS2AD ("enter_bs_date") // BS date format (YYYY/MM/DD)
- ConvertDateFormat ("date", "source_format", "target_format")
- BsDatesDiff ("start_date", "end_date") // Date count between 2 BS Dates
- BsAddDays ("bs_date", no_of_days") // Add or Subtract number of days from a BS Date
- number2unicode (number)
- unicode2number (unicode_number)
- number2words (enter_number) // Assign the font as Preeti
- number2words_preeti (enter_number, show_units) // the output is in Preeti font, and show_units specifies if you want to get units (
- number2words_unicode (enter_number, show_units) // Assign the font as Preeti
- number2words_english (enter_number, show_units)
- font2unicode ("preeti/kantipur text") // Converts text written in preeti/kantipur to unicode text
- unicode2font("unicode text") // Converts text written in unicode to preeti/kantipur font
Available Formats:
- YYYYMMDD
- MM/DD/YYYY
- MM-DD-YYYY
- YYYY/MM/DD
- YYYY-MM-DD
- DD/MM/YYYY
- DD-MM-YYYY
- YYYY.MM.DD
- DD.MM.YYYY
You can download the file here:
How to Install:
Please watch the video below on how to install the "Nepali Excel Addin" on your system. Go to How to install Nepali Excel Addin to view the step by step instructions.
Available Functions:
Date Functions:
| AD2BS ( "enter_ad_date" ) Example: AD2BS( "12/25/2016") // Returns 2073/09/10 Returns the converted BS date |
| AD2BS ("Date", "Source Format", "Target Format") Example: AD2BS("07/07/2020", "MM/DD/YYYY", "YYYY-MM-DD") // Returns 2020-03-23 Returns the converted BS date |
| BS2AD ( "enter_bs_date" ) Example: BS2AD( "2073/12/25") // Returns 4/7/2017 Returns the converted AD date |
| BS2AD ("Date", "Source Format", "Target Format") Example: BS2AD ("2077/03/23", "YYYY/MM/DD", "YYYY-MM-DD") // Returns 2020-07-07 Returns the converted AD date |
| ConvertDateFormat( "enter_date", "source_format", "target_format" ) Example: ConvertDateFormat( "2073/12/25", "YYYY/MM/DD", "YYYY-MM-DD") // Returns 2073-12-25 Returns the converted AD date |
| BsDatesDiff( "start_date", "end_date" ) Example: BsDatesDiff( "2073/2/3", "2073/2/5" ) // Returns 2 Date count between 2 BS Dates |
| BsAddDays( "bs_date", no_of_days ) Example: BsAddDays( "2073/2/3", 5 ) // Returns 2073/2/8 Add or Subtract number of days from a BS Date |
Number Functions:
| number2unicode( number ) Example: number2unicode( 12345 ) // Returns १२३४५ Convert number to unicode text |
| unicode2number( "unicode_number" ) Example: number2unicode( "१२३४५" ) // Returns 12345 Convert unicode number to number |
| number2words( enter_number, show_units ) Example: number2words( 123 ) // Returns Ps ;o t}O; 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_preeti( enter_number, show_units ) Example: number2words_preeti( 123 ) // Returns Ps ;o t}O; 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 ) Example: number2words_unicode( 123 ) // Returns एक सय तेइस रुपैंया Returns the result in unicode. Here show_units is optional and set to false by default; Shows paisa count if set to true. |
| number2words_english( enter_number, show_units ) Example: number2words_english( 123 ) // Returns One Hundred and Twenty Three Returns the result in nepali system ( crore, lakh, thousand ). Here show_units is optional and set to false by default; Shows paisa count if set to true. |
Font / Unicode Functions
| font2unicode( "preeti/kantipur text" ) Example: font2unicode( "g]kfn" ) // Returns नेपाल Converts text written in preeti/kantipur font to unicode text |
| unicode2font( "unicode text" ) Example: unicode2font( "नेपाल" ) // Returns g]kfn Converts text written in unicode to preeti/kantipur font |
You can download the file here: