Can anyone help me to convert excel column in 2 decimal from “$” currency in each cell.
I attached sample excel file with 2 sheets.
Sheet Input: I am getting this type of column every day.
Sheet Output: Need output as shown.
Thank YouSample.xlsx (124.6 KB)
Main.xaml (10.6 KB)
Thank You Nived , I did tried the code you sent but numbers are coming as text, which is not my desired output.
And again some of the numbers with value .00 are not coming in 2 decimal. See below.
Attached new sample xl. New Sample.xlsx (155.1 KB)
Need to remove text format from columns.
Can you try with format value and check
For each column , i have tried remove the dollar symbol and replace empty string. Then followed by autofill range can be used .
Thanks for sharing . Will try this one and is this remove text format? I also want to remove text format. my column have umber value stored as text.
Would you mind to give me sample?
you can use it like this.
FormatNumbersInExcelColumn_VBNET.xaml (5.2 KB)
It is only for column A in Sheet1. You can also add it for Column B and Column C and for the other sheet.
If you need help, please write me back.
Thank you so much for sharing code.
Below error getting.
Do I need to use Write range? or any other parameters?
Invoke code: Exception has been thrown by the target of an invocation.
Thanks for sharing but this is not working for me. Would you mind to share me sample file?
maybe you don’t have the package Microsoft.Office.Interop.Excel.
Please import it so you can run the code without problems.
Watch this video to learn how to import this package, if you don’t know how to do that.
Is there any way that I want to Auto fill upto A column.
If A have 100 rows then I want to Auto Fill only 100. I don’t know how many rows will come each day.
Hey code is working thanks.
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.