Excel column with currency value to convert into 2 decimal

Help Studio
, ,
1

Urgent Question.

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)

2

Hi @pari_patel
check this
Main.xaml (10.6 KB)

Regards,
Nived N

3

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.
image

4

Attached new sample xl. New Sample.xlsx (155.1 KB)
Need to remove text format from columns.

5

Hi @pari_patel

Can you try with format value and check

Thanks
Ashwin.S

6

Hi ,

For each column , i have tried remove the dollar symbol and replace empty string. Then followed by autofill range can be used .

image

7

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.

8

Would you mind to give me sample?

9

Hi @pari_patel

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.

Best regards
Mahmoud

1 Like
10

Hey @Dawodm

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.

11

Thanks for sharing but this is not working for me. Would you mind to share me sample file?

12

maybe you don’t have the package Microsoft.Office.Interop.Excel.

Please import it so you can run the code without problems.

Best regards

13

Watch this video to learn how to import this package, if you don’t know how to do that.

15

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.

16

Hey code is working thanks.

17

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