Spell the figures in Text (User defined formula) for Excel & VBA
Dear friends... We often look / require a formula who can spell the figures in text. In most of the reports we prepare we require to mentioned the figures / amount in text also. In some report this is mandatory to mention the same in text like bank deposit slips, any reports prepared for government department, etc etc. But there is no such inbuilt formula in excel who can do this automatically. ** But now we can do the same with a UDF (user defined formula). Let’s see how.. Copy and paste the following programme in the excel module. Module??? Ohhh. For that following the following steps: - 1. Right click on any sheet and select View Code 2. In the top left of the window you will find the list of sheets 3. Right click on any sheet and then click insert and then click module 4. A module window will open. Now copy paste the following codes into it. Function SpellCurr(ByVal MyNumber, _ Optional MyCurrency As String =