Here is a screenshot of how this tool works. If you think this can be useful to you, you can follow the instructions in the description below:
How it works in MS Excel
In Excel you will use a custom formula to convert the unicode text to legacy text and vice versa.
![](https://sushilparajuli.com/wp-content/uploads/2022/03/Excel.png)
How it works in MS Word
In Word you will use a shortcut key / ribbon shortcut to convert the unicode text to legacy text and vice versa.
![](https://sushilparajuli.com/wp-content/uploads/2022/03/Word1.png)
![](https://sushilparajuli.com/wp-content/uploads/2022/03/Word2.png)
Installation Instruction for Excel
Step 1: Download the Excel Addin File from this link.
Step 2: Install the Addin File
(i) Open your “Microsoft Excel”
(ii) Go to “Files”
(ii) Go to “Options”
(iv) Go to “Add-ins” tab in the new window
(v) At the bottom at “Manage” Section choose “Excel Add-ins” and click “Go”
(vi) Click “Browse” and browse and select the file downloaded from Step 1
(vii) Click “OK” and return to Excel Spreadsheet
Step 3: You can start to use the tool.
Step 4: The Functions
UnicodeToPreeti(UnicodeText)
PreetiToUnicode(PreetiText)
Note:
This function only has a single argument for the input text and nothing else. It’s fairly simple.
Follow this post for more updates. You can later download more latest version of this tool here in this same post.
Installation Instruction for Word
Step 1: Download the Word Addin File from this link.
Step 2: Install the Addin File
(i) Open your “Microsoft Word”
(ii) Go to “Files”
(ii) Go to “Options”
(iv) Go to “Add-ins” tab in the new window
(v) At the bottom at “Manage” Section choose “Word Add-ins” and click “Go”
(vi) Click “Browse” and browse and select the file downloaded from Step 1
(vii) Click “OK” and return to Word Document
Step 3: Assign a shortcut key or ribbon shortcut
At this stage you already have the tool. You just need to either assign a keyboard shortcut to the macro or enable a button in the toolbar area.
(A) You can either assign a shortcut key:
(i) Go to “Files”
(ii) Go to “Options”
(iii) Go to “Customize Ribbon” tab in the new window
(iv) At the bottom at “Keyboard shortcuts” section choose “Customize”
(v) On “Categories” group select “Macros” and on “Macros” group select the required macro
(vi) Press shortcut key and click “Assign”
(vii) Click “OK” and return to Word Document
(B) Or, you can setup a ribbon shortcut:
(i) In the top of the ribbon area click “Customize Quick Access Toolbar” and go to “More Commands”
(ii) On “Choose Commands from” group select “Macros” and select the required macro
(iii) “Add” the macro to the other group
(iv) Click “OK” and return to Word Document
Step 4: You can start to use the tool
You can start to use the tool.
Follow this post for more updates. You can later download more latest version of the this tool here in this same post.
very much helpful converter. Thank You
Very Helpful, thanks
Can you also make a similar tool file that can spell out words in both english and nepali
eg. for 1234567.90
formula 1 – Twelve lacs thirty four thousand five hundred sixty seven and ninety paisa
formula 2 – बाह्र लाख चौतीस हजार ….
thank you!
hey, I think, this is what you are looking for: https://sushilparajuli.com/number-to-word-tool-for-excel/
Yes, Thank you!!
Mac ma kasari garne hola word ma, pls help garidinuhola,
To my knowledge, mac doesn’t support VBA so this tool will not work – there must be other alternatives – but I am not sure.
This tool Can I Use Google Sheet and Google Docs
No this doesn’t work with Google Sheets – Google Sheets uses JavaScript but MS Excel uses VBA – completely different programming tools.
Could you please update the macro to render these letters properly in unicode, To;n] cfk”mn] tkfO+{
Bro but the number is not changing like 1 is not changing to ekk and if i select all the paragraph having number it shows error
Can you help me with that…………..
Thank you so much!
thanks
i am searching such tools. thank you very much.
and one thing default font size is 16. how can i change it.