I trying to program a Subroutine to replace a "." for a "," in a column of imported data in order to convert this text into numbers with decimals:
1.0000 --> 1,0000
If I do manually or with a Macro I get the result, if I use the same code than in the Macro for the subroutine I get an undesired result:
1.0000 --> 10000
Do you any idea ?
1.0000 --> 1,0000
If I do manually or with a Macro I get the result, if I use the same code than in the Macro for the subroutine I get an undesired result:
1.0000 --> 10000
Do you any idea ?