Number in decimal Format in text file generate from Excel VBA

Hi, I have searched a lot but find no answer. Hope someone helps me in this context.
I am using a vba code to create a text file from an excel sheet. The code works fine. But there is a number format in decimal in excel which converts as a number without a decimal place in the text file. below is the code I used.

Please Login or Register  to view this content.

Hope someone helps me to overcome my difficulties.

Thanks in advance

Thanks for your response.

All data in the excel file is in text format only one column of data is in number format like e.g. 6000.00
After the text file generates the number data look like 6000.

applying the format to the "Else" line gives me the same result.

Thanks

A sample file is attached.
Its Created the TD.text file but I want the text file as "Expected Result.txt" file content.

Hope for the best.

I don't understand your question "How did I do without being able to test it?". I tried the above code but it debugging. If I remove the Stop 'For debugging purposes the result is the same as before.

Thanks

Hi,

what is your system decimal separator ?