Forum Discussion

Oliullah_Siddique's avatar
Oliullah_Siddique
Brass Contributor
Jul 18, 2022
Solved

Value to text in EXCEL

Hello,

In Cell Q2 the value is 262,043.23

 

In Cell B5 it shows Twenty two paisa only. (It should have been TWENTY THREE)

 

I have attached the Excel file.

 

Thanks in advance.

 

 

excel
Formulas and Functions
  • Riny_van_Eekelen's avatar
    Riny_van_Eekelen
    Jul 18, 2022

    Oliullah_Siddique You need to round to number to two decimals. As you have it now, Excel displays the number with two decimals, but the underlying number is 262,043.225. The macro picks-up the 22 as the decimals.

    Use ROUND( your_formula_here , 2 )

4 Replies

  • Riny_van_Eekelen's avatar
    Riny_van_Eekelen
    Platinum Contributor
    Jul 18, 2022

    Oliullah_Siddique You need to round to number to two decimals. As you have it now, Excel displays the number with two decimals, but the underlying number is 262,043.225. The macro picks-up the 22 as the decimals.

    Use ROUND( your_formula_here , 2 )

    • Oliullah_Siddique's avatar
      Oliullah_Siddique
      Brass Contributor
      Jul 18, 2022

      Riny_van_Eekelen

      I used the formula. But showing error:
      ="In words: Tk."&" "&ROUND(SpellNumber(Q2),2)

      The original formula is given below:
      ="In words: Tk."&" "&SpellNumber(Q2)

      Would you please check it.

Resources