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 !
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 !