Dot is replaced by a comma

[SonnyTito]

Hi all,
I have written some VBA code where a user selects a code from a dropbox.
The selected code is eg. 01.01
If I put this choice into a variable and put the variable content into a cell, 01.01 becomes 1,01, which is not what I want.

I have simulated this in an easy way with following code:
Range("A5").Value = Range("A1").Value

Even if A1 contains 01.01, the cell contact of A5 will be 1,01

Any suggestions how to prevent this?

Thank you !

 

[mole999]

it will be in control panel, country settings generally

otherwise options > advanced and scroll down to editing options, look at use system seperators

 

[Rick Rothstein]

I have written some VBA code where a user selects a code from a dropbox.
The selected code is eg. 01.01
If I put this choice into a variable and put the variable content into a cell, 01.01 becomes 1,01, which is not what I want.

I have simulated this in an easy way with following code:
Range("A5").Value = Range("A1").Value

Even if A1 contains 01.01, the cell contact of A5 will be 1,01

Any suggestions how to prevent this?

Assuming cell A5 is where you are putting this value, execute this code line before you put the 01.01 value into it...

Range("A5").NumberFormat = "@"

That will set the cell's format to TEXT so that Excel won't try to interpret the code a number.

 

[SonnyTito]

Assuming cell A5 is where you are putting this value, execute this code line before you put the 01.01 value into it...

Range("A5").NumberFormat = "@"

That will set the cell's format to TEXT so that Excel won't try to interpret the code a number.

Thank you Rick.
This works fine