Copy csv file to excel with decimal problem after decimal point

Help Forum
22

Sure, bcause it is thousands separator.

1 Like
23

i need to keep this configuration system in my computer

24

Hi @Soudios

image
image808×272 12.2 KB

It’s Working Check the screenshot.

Regards
Gokul

1 Like
25

@Gokul001

Its working with a specific number i need it to work with a hole csv file

26

Hi @Soudios

Share the CSV file

1 Like
27

@Gokul001
I can’t share it with you, what do you need to know about the csv file ?

28

Hi @Soudios

Can you share a dummy CSV file and error screenshot

1 Like
29

As stated before it seems to be locale settgins conflict:

  • your CSV is using comma as decimal separator
  • your system is comma as thousands separator

I recommend you to resolve it by replacing “,” by “.” in your number, e.g.
MyNumber = “123,456”
MyNumber = MyNumber.replace(“,”,“.”)

This is a dummy solution but should work.

Cheers

1 Like
31

image
image

image
image1020×27 1.23 KB

image
image704×154 3.03 KB

image

image

32

@Soudios

Can you share the Dummy CSV file?
Otherwise, I cant help you…

1 Like
33

Here an example of numbers with 2 decimal after coma
image

34

in your code i need to replace “MyNumber” by a csv file

35

The solution proposed by @ppr before works well for all variants:
1 234,56 → 1234.56
234,56 → 234.56
234,567 → 234.567
1 234,567 → 1234.567

MyNumber = “1 234,56”
MyNumber = Double.Parse(MyNumber, System.Globalization.CultureInfo.CreateSpecificCulture(“fr-FR”)).ToString

Howgh

1 Like
36

@J0ska

I have 200000 row in this file, did a need to add MyNumber= “1 234,56” 200000 times ? :slight_smile:

37

This is a different story - you read CSV into a datatable and seems you do not know how to apply the formula to the datatable.

Cheers

1 Like
38

How can i do that ?

39

This is quite common topic. Many resources about this topic in this forum and Internet.
Search pls.

Cheers

40

@J0ska
Ok no problem if you don’t know how to do it

41

Anyone knows how to do it with the hole process plz ?

42

Hi ,
Can you try this method, auto fill range can be extended till last row.Main.xaml (8.8 KB)
sample.xlsx (8.7 KB)