to convert cell format

I am using french language version of the excel !

here the decimal separator is " ,".

I have some 8000 data values with decimal separator ".".

This is the format of the exsiting cell " +1.0000000000000000E+00 ".

I need to have this converted to "1,00".

I would like to have a macro which u cud do this perform!

Thanks a lot for ur time!

regards
Taniks

Doesn't a simple "Replace..." command do the trick?

Edit Menu - Replace "." with ","

In Portuguese version, we use shortcut Ctrl + U .