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:

Please watch the video below on how to use the various date functions below.

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:

Please watch the video below on how to use the various number functions below.

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:

Comments

comments