Import file and convert decimal point to comma

Hi Oeldere, thanks for your quick reply. But im not looking for the replace function usage. I know i can do that. But i have to import this file every day or so and dont want to keep doing that.

How can i do that with a macro? Thats what im looking for.

For your b) question you could test this macro and see if it works for you.

Please Login or Register  to view this content.

To get help with your a) question you stand a better chanse getting help if you upload a sample text file.

Alf

Hi Alf,

your solution for b) works perfect, thanks!

With this post i uploaded a sample text file.

And if you have a macro for that, can I then just merge the two macro actions in (so between "Sub ()" and "End Sub" where I put the macro for opening the file before the replacement thing so it processes in that order?

This macro imports a specific file from a specific folder. You will have to change the file name and the folder to suit your needs.

Excel also had some problem "converting" 3.2800000000000002 to number (there was 2 or 3 more like that. It seems Excel could not cope with this and made a number without any delimiter 18 digits long. So I had to test cells and if they contained 18 numbers if so the macro chops them down to 8 a number that Excel seems to be happy with.

Please Login or Register  to view this content.

Alf

wow, that is awesome thanks a lot! This is the perfect thing. I appreciate it you looked into the file and made sure that those big numbers are now also converted properly

One last question remains. By running this macro it imports the data perfectly. But, if i want to do some calculations with it and then later import the file again (say next day, with new data). How would you go about this?
Because right now, if i run the macro again to import the data, no matter what cell or column is selected, it always imports it next (right side) to the data previously imported into the file. Also, it overwrites any data in those cells, where my calculations are.
I would prefer to have it below or above the before-imported data.

Macro adjusted i.e. using "Offset" command imported files will be placed beneath each other.

Was not too happy with my first "error" trapping so I've changed it to check for a "." in the cell value and that the number of "values" must be 18 or bigger. If both conditions are fulfilled then it will find the position of "." and add 3 so you will get 3 decimals after the "."

If this is not sufficient increase 3 to 5 or 6.

Please Login or Register  to view this content.

Alf

Hi Alf,

Sorry for my late response. Your solution works perfect, thanks for your help!

No problem! Thanks for feed back and as your problem now seemed solved could you please mark it "Solved"

Alf

To mark your thread solved do the following:
- Go to the first post
- Click edit
- Click Advance
- Just below the word "Title:" you will see a dropdown with the word No prefix.
- Change to Solve
- Click Save