Introducing AlatiphA Currencies: A Dynamic Excel Add-in for Currency Formatting

By -

 

Do you find yourself repeatedly formatting numbers and currencies in Excel? 

Whether you're a finance professional, an accountant, or simply a power user of spreadsheets, managing currency formats can be time-consuming and tedious. 

Enter AlatiphA Currencies, an innovative Excel add-in that simplifies formatting tasks with a suite of powerful macros.

Key Features of AlatiphA Currencies Add-in

The AlatiphA Currencies add-in includes four primary macros designed to streamline your workflow. Here’s how they work:

1. Format Currency

This macro applies customized currency formats to any selected range, supporting multiple currencies like Ghanaian Cedis (GH¢), US Dollars ($), Euros (€), British Pounds (£), Japanese Yung (¥) and Nigerian Naira (NGN). 

  • Note: The Nigerian Naira currency symbol (₦) is not compatible with the VBA editor. So, the ₦ is automatically converted to "?" when entered in the editor. This makes it difficult to use the symbol as a currency. Hence, the use of the abbreviation NGN for ₦) 

You can specify whether to include decimal places, making it perfect for financial reporting or transaction summaries.

How It Works:

  1. Prompts user to select a range of cells.
  2. Asks for user's preferred currency symbol and whether decimals should be displayed.
  3. Applies a professional number format that matches your requirements.


2. Format as GH¢ (Ghanaian Cedi)

Specifically tailored for users who frequently work with Ghanaian Cedis, this macro simplifies the process further. 

A simple prompt lets you choose whether to format with or without decimals.

User Experience:

1. Select a range to format. 

2. Click on the Cedi icon. 

3. Choose whether to display decimals.


4. Click on Ok! 

  • Why It’s Useful: This macro saves you from manually editing formats each time and ensures compliance with regional formatting standards.


3. Multi-Currency Formatting

With businesses operating globally, it’s common to work with multiple currencies in the same spreadsheet. This macro supports formatting for:

  1. GH¢ (Ghanaian Cedis)
  2. $ (US Dollars)
  3. € (Euros)
  4. £ (British Pounds)
  5. ¥ (Japanese Yung )
  6. NGN(Nigerian Naira)

User Experience:

1. Select a range to format. 

2. Click on the globe icon. 

3. Choose a currency symbol from an intuitive menu.

4. Specify whether to display decimals.

5. Click on Ok! 

Error Handling:

If an invalid option is entered during the prompts, the macro provides clear instructions for retrying. This ensures a user-friendly experience every time.


4. Add "GH¢" to Empty Cells

This macro goes a step further by allowing users to populate empty cells with the "GH¢" symbol. It’s especially useful for marking placeholders or templates in financial documents.

User Experience:

1. Select a range to format. 

2. Click on the drop down arrow under the globe icon Insert GH¢. 


3. Click on Ok! 


Unique Features:

  • Works only on empty cells, ensuring no accidental overwriting of existing data.
  • Automatically centers the text in the cells for better aesthetics.

Seamless User Experience

The AlatiphA Currencies add-in is built with robust error handling and clear user prompts. Here are a few examples of its thoughtful design:

  • Validation of Selection: Ensures users select a valid range before proceeding.
  • Protection Checks: Prevents modifications to protected sheets, safeguarding your data integrity.
  • Interactive Prompts: Guides users through choices for currency symbols and decimal preferences.

Why Use AlatiphA Currencies?

This add-in isn’t just about formatting—it’s about efficiency and accuracy. By automating repetitive tasks, it allows you to focus on analyzing data and making decisions. Plus, its flexibility to handle multiple currencies ensures it fits seamlessly into any workflow.

Get Started Today

The AlatiphA Currencies add-in is your go-to solution for professional-grade currency formatting in Excel. Whether you're formatting a simple invoice or creating a complex financial report, these macros will save you time and improve accuracy.

Ready to try it out? Add the AlatiphA Currencies add-in to your Excel toolkit today, and elevate your spreadsheets to the next level!

Get the add-in below:

How do download:

1. Click on the the preview icon on the top right corner. 

2. Click on the download arrow button at the top. 


For how to download, click here!

Comments

Post a Comment

Latest News

Unlocking Productivity with Excel Add-ins: A Comprehensive Guide

By -
Image
In the fast-paced digital age, efficiency and automation are essential for businesses and individuals alike. Microsoft Excel, a cornerstone of data analysis and management, becomes even more powerful when paired with Excel Add-ins . These add-ons expand Excel’s functionality, tailoring it to specific tasks and making complex processes manageable. What is an Excel Add-in? An Excel Add-in is a supplementary program that enhances the capabilities of Excel. Add-ins can be developed using VBA (Visual Basic for Applications), COM (Component Object Model), or JavaScript-based Office Add-ins. Whether you need advanced data visualization, automated workflows, or seamless integration with other software, add-ins bridge the gap between your needs and Excel’s out-of-the-box features. Benefits of Using Excel Add-ins 1. Automation and Efficiency Add-ins automate repetitive tasks, reducing manual effort and the likelihood of human error. From complex calculations to generating reports, they save va
Read more

ICT for JHS

By -
Image
If you are looking for  ICT  notes for  JHS , then you are in a right place. This book has been written in accordance with the current syllabus for the  Basic Education   Certificate Examination (B.E.C.E)  for  Junior High Schools (J.H.S) . The book covers the three year syllabus . This book will provide you ICT notes and step by step tutorials with definitions, explanations, examples and illustrations. This book is created to make the teaching and Learning of ICT lively, handy and encourage students to use their phones, tablets and computers for learning. The book will also help you learn anywhere and at anytime. PREVIEW BELOW
Read more

OFFICIAL: GES Opens 2023 promotion Portal - Apply Here

By -
Image
  The management of the Ghana Education Service (GES) has issued a statement to invite suitable qualified serving officers/teachers to apply for consideration for promotion to the ranks or grades of: Deputy Director Assistant Director I  Assistant Director Il  Principal Superintendent  Read Full Statement below: How to apply   1. Launch a browser (e.g. Chrome).  2. Enter the URL below:  https://www.gespromotions.gov.gh/   in the address bar.  3. Tap/click on Apply for Promotion.   4. Choose Teaching Staff from the options provided. (You can also choose Non-teaching ).  5. Click on  Start a New Application . 6. Complete the form that pops up and tap/click on  Start Application.  Note : The staff ID is to be confirmed.  7. Another form will pop up, with the following portions already filled: Application code Staff ID  Primary Phone number  Grade or rank applying for.  With the warning that,  " NB : Kindly copy and save the  Application Code  &  Staff ID . This code will be used
Read more

How to register and access the PLC site as Headteacher

By -
Image
  Registration   1. Launch a browser e.g. Chrome  2. Enter the URL - plc.gov.gh in the address/search bar 3. Tap/click on Create Account  4. Tap/click on Head teacher/Head icon 5. Enter your school's NEW EMIS CODE e.g. 1121210558555  6. Select and confirm school's details  7. Complete the rest of the form by entering: You Full Name  Your Phones Number and  The school's Corporate GES email address . E.g. alatiphakgpri@ges.gov.gh  8. The username field will be populated with a username based on the email address as you can see in the above screenshot with alatiphakgpri_head as the username  9. Enter and confirm the corporate  password .  Note : The password is  TempPass1@?  for all schools  10. Tick ✅ to agree to the term, conditions and policies  11. Tap/click on Create   Signing In  1. Launch a browser e.g. Chrome  2. Enter the URL -  plc.gov.gh  in the  address/search  bar 3. Enter the school's credentials. These may be: Username :  alatiphakgpri_head (as aut
Read more

Popular Posts

ICT for JHS

By -
Image
If you are looking for  ICT  notes for  JHS , then you are in a right place. This book has been written in accordance with the current syllabus for the  Basic Education   Certificate Examination (B.E.C.E)  for  Junior High Schools (J.H.S) . The book covers the three year syllabus . This book will provide you ICT notes and step by step tutorials with definitions, explanations, examples and illustrations. This book is created to make the teaching and Learning of ICT lively, handy and encourage students to use their phones, tablets and computers for learning. The book will also help you learn anywhere and at anytime. PREVIEW BELOW
Read more

Regular BECE ICT Pasco

By -
Image
This book contains regular Basic Education Certificate Examination (BECE) Past Questions for Junior High Schools (J.H.S) by West Africa Examination Council (WAEC). Included in this book are Past Questions & Answers for the years: 2011, 2012, 2013, 2014, 2015, 2016, 2017, 2018, 2019, 2020, 2021, 2022 & 2023. This book, I strongly believe, will bring success to all users who study it carefully. PREVIEW BELOW 
Read more

Gov’t Intervenes As Court Orders Auctioning Of GHANASCO Cars

By -
Image
The Northern Regional Director of Education, Mohammed Haroon Cambodia has confirmed government will be paying a staggering GHC400,000 as judgment debt to a private citizen in order to stop the auctioning of vehicles belonging to the Ghana Senior High School in Tamale. Government is offering the bailout following a chronic transport difficulty that has hit the school for the last two years after a court order impounded the only bus for students and a brand new official pickup vehicle. Two Nissan patrol vehicles belonging to the Education directorate were also taken by the court. The vehicles were confiscated to be auctioned to pay up salary arrears of a former headmaster of the school who accused the school and education service of injustices including inappropriate dismissal and concealing his promotion letter. Late Lionel Mahama was dismissed as headmaster of the school in 1997. His salary was blocked for years until a CHRAJ ruled in his favor and ordered his reinstateme
Read more


AlatiphA is an Education and Technology blog that provides quality contents on education and technology.

AlatiphA is optimized for news, ebooks, educational templates, training, learning, testing (quizing) and many more.

Tutorials, eBooks and tests are constantly reviewed to avoid errors but we cannot warrant full correctness of all contents.

While using this blog, you agree to have read and accepted our:

Disclaimer,
Terms of use
&
Privacy policy.

We're Social