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
Reply With Quote
