Replace "." using Macro

Hi All,

I am newbie to macros and basically I am a SAP BW consultant.

in my report output screen, I need to remove "."s in two cells.

Example:
Col: A Col : B
Month Start 202.001
Month End 202.012

I need to remove "." using macros (not using Ctrl+H), because every time when I refresh the data dots should not come. Users getting confuse with theses values.

please help me how to write.

thanks in advance.

Very simple like:

Please Login or Register  to view this content.

Thanks Jec,

It is working fine, when I click on run macro. but when data refreshed or column added/removed again it is falling back same format, and again I have to click run.

I think, code should update before refreshing the data. do you know how to find.

How are you refreshing that data?