How to put dot for 1k numbers to excel column

[Kuki_Force (KukiElec.)]

Hi everyone,

I have specific columns. If more than or equal to 1k numbers, the numbers should be like this
=> insted of 4500 => 4.500 (should be dot not comma)

how can i do that?

Thank you.

[jack.chan]

if num (integer) = 4500

num.ToString("N3")
will output 4.500

@Kuki_Force

[Anil_G (Anil Gorthi)]

@Kuki_Force

Please try this

cdbl(VarNumberString).ToString("N2", New System.Globalization.CultureInfo("de-DE"))

Cheers

[Kuki_Force (KukiElec.)]

@jack.chan @Anil_G
I want to enable to this check box(“Use 1000 Separator(.)”) as you can see in the picture with specific columns.

Thank you.

[jack.chan]

paste below code in file vba.txt

Function changecolumnFormat(columnLetter)
Sheets("Sheet1").Activate
Columns(columnLetter & ":" & columnLetter).Select
Selection.NumberFormat = "#.##0"
ActiveWorkbook.Save
End Function

2. in excel application scope call invoke vba
   pass in
   file = vba.txt
   function = changecolumnFormat
   parameter = {columnLetter to format} e.g. {“A”}
   
   

[Anil_G (Anil Gorthi)]

@Kuki_Force

check

@Kuki_Force

Use format cell activity

cheers

[Kuki_Force (KukiElec.)]

The code works fine but it didn’t use dot intead of comma.
result like this.

Why excel translating dot to comma i did not understand. and also putting decimal place even we did not do any decimal code or etc.

thank you.

[Kuki_Force (KukiElec.)]

result like this

[Anil_G (Anil Gorthi)]

@Kuki_Force

If you manually us that option is it working?

Ideally it should be

Cheers

[jack.chan]

can you send me your excel?

[Kuki_Force (KukiElec.)]

@Anil_G and @jack.chan i found the answer.

As Anil mentioned, the “use format cell activity” was correct . But i should have changed the category type and specified the type.

I did this ;

Thank you both for your help.

Best wishes.