Subscribe Our Notifications YouTube Subscribe!

Nepali Functions Addin for Excel

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:

Post a Comment

Oops!
It seems there is something wrong with your internet connection. Please connect to the internet and start browsing again.
AdBlock Detected!
We have detected that you are using adblocking plugin in your browser.
The revenue we earn by the advertisements is used to manage this website, we request you to whitelist our website in your adblocking plugin.
Site is Blocked
Sorry! This site is not available in your country.