Convert to Number , percentage result cell

Hello,

I am running some query to get the percentage, but it gives me the result as text, how i can convert it to a Number?

Thank you

@coder write simply in excel file then run macro to change column format. It will change your column

@raja.arslankhan is there another way?

@coder you can convert to int32, in64 and double as well. Can you show me data sample

Thank you , i have solve it .

using this

Yes, you can change the format of the values in Excel and save the file. You can use the Format Cells dialog box in Excel to change the format of the values. To do that, you can follow these steps:

you can change the format of the values in Excel and save the file. You can use the Format Cells dialog box in Excel to change the format of the values. To do that, you can follow these steps:

  • Select the cell or range that you want to format.
  • Right-click on the selection and choose Format Cells from the context menu.
  • In the Format Cells dialog box, go to the Number tab and choose the category and options that you want for your values. For example, if you want to format your values as numbers with two decimal places, you can choose Number from the category list and set the Decimal places to 2.
  • Click OK to apply the format and close the dialog box.
  • Save the file using Ctrl+S or File → Save.

@coder
oh its manual method. I was thinking you want to do through Dipath. hurrah

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.