Decimal separator changes when exporting to a txt file

[Lysebjerg78]

Hi everyone

I hope someone here is able to help me, cuz I haven't succeed in finding the right way myself.

I have made some macros helping me importing data from a txt fileand to sort the data into a sheet ready to be exported into another txt file. I have made VBA helping me to work with "." as decimal separtor within the spreadsheet.

But, when I run the macro to export the data into a txt file (I have used the macros from this site http://www.cpearson.com/excel/ImpText.aspx) it automatically changes all "." into ","

But why?!?

I need the txt file to load data into another program, and this program need the use of "." as decimal separator - and not ",".

I'm using an European windows system...

BR
Lysebjerg78

 

[jimrward]

try checking your language and keyboard settings in the control panel for list and decimal separators

 

[AlphaFrog]

If your numbers are displayed in Excel with "." as decimal separator, then try changing this line in the macro...
CellValue = Cells(RowNdx, ColNdx).Value

To this....
CellValue = Cells(RowNdx, ColNdx).Text

 

[Lysebjerg78]

Hi,
thanks a lot for your reply!

The "text"-trick solved the problem

BR Lysebjerg78

 

[kasperke]

I have the same problem, using the same macro, but the (colleague's) computer also shows the decimal separator as a comma in the file. So I need to find a way to change the , into a . before exporting. Any simple ways to do this?

 

[kasperke]

I found a solution, using

CellValue = Cells(RowNdx, ColNdx).Value

but then

CellValue = Replace(CellValue, ",", ".")