Therefore, to achieve this goal, we have to follow the steps described below: Step 1: Arranging Dataset To understand easily, we’ll use a sample dataset as an example in Excel. In this case, we have Peso Number in Column B and English Words(Peso) in Column C. Step 2: Opening New ...
Step 4 – Applying the User-Defined Function to Convert Numbers to Words in Excel in Rupees You will get a window ofthe Word function. Select the first number from columnB. ClickOK. The first number is converted to words in rupees. Use theFill Handletool and drag it down from cellC5toC...
Read More:How to Convert Peso Number to Words in Excel Method 2 – Applying the VLOOKUP Function to Convert Numbers to Words Steps: Write down all the numbers in words manually in theC column. Use the following formula in theC12cell. =VLOOKUP(B12,B4:C9,2,FALSE) PressEnter. Formula Break...