Hello all,

1st, let me thank you for the great job you are doing with this forum: I use it a lot to grab examples as I am quite newbie in VBA programming.

I'd have a request for a sample code to be implemented in a wider spreadsheet.

I copy and paste a set of data from a webpage to an Excel file.

The data imported as numbers have some decimal separator which from time to time is not the same of the system where I import the data.

I would like to create a macro which:

1 - Detects the decimal separator (comma or full stop) actually used by Excel: the system must work in different versions which can have different separators
2 - Replaces the commas in the whole spreadsheet with the correct decimal separator
3 - Replaces the full stops in the whole spreadsheet with the correct decimal separator
(I don't mind if the action is redundant or not efficient, as I do not operate on a too wide set of data)
4 - Formats all the columns from D to G, from the second row to the end of the spreadsheet, as numbers

So that I can later on process the data as numbers.

I can easily do it manually, but just because I know which is the right decimal separator for my Excel; I need this operation to be automated in order to work on an Excel file of any other person.

Thank you all again,

Marco