Macro to replace symbol

[Ilko]

I’m using a large database – excel based, with lots of VBA and macros inside – where the default decimal format is “.” (period). When I copy and paste into a normal excel workbook format I want to replace the periods with comas. The paste function I’m using is “Match Destination Formatting (M)”.

I’ve recorded a macro to replace all of the periods with comas – still some of the values come up as a whole number, the period not being replaced with the coma.
I’ve tried almost all of the formats – text, general, number… Still does not work.

Would someone tell me what am I doing wrong and how can I fix?

Thanks,
Ilko

[john55]

try this

Please Login or Register  to view this content.

[Ilko]

John - thanks.

The problem is that I do not know VBA. When you say cells.replace ".","," I dont know what to do.
I'm only working with the existing within excel functions and formulas...

Would you simplify your example, please?

Thanks again

[john55]

k, make a copy of yr file, a test file, then hit Alt+F11, insert module, copy-paste this piece of code

Please Login or Register  to view this content.

then hit Alt+F8 and run "replace".
hope it helps you

[Ilko]

After opening the module there is some script - do I paste it at the very beginning, at the end, somewhere in the middle of the module?

After hitting Alt+F8 there is no "replace" to run...

Apologies again, but I dont know VBA...

[john55]

yeap, copy-paste the whole code posted, from "Sub...to end sub"

[Ilko]

Unbelievable - it works... Thanks a lot, John!!!

[john55]

glad to help you!
if you are happy with the solution provided, please mark the thread as Solved.
thx!