No, it didnt help. I'll try to explain that situation better.

I'm using commas as decimal separator, but data that I work with, come
from another application (web-based) that uses dots as separator. When
paste data tables to a Excel chart all numbers are handeled as text. M
objective is to convert them to the numbers.

After using Replace function in macro it replaces dots with commas, bu
numres are still text and can't be ussed in financial functions. I
helps when I manually edit cell (F2) and hit Enter after that, but
cant edit all 500 cells manually.

When I use Replace function from Edit menu manually, it work perfectl
and I dont have problem with number that are in text format.

I have tried also to change format of cell in every way but it doesn
work. Work only F and Enter

--
maxes
-----------------------------------------------------------------------
maxest's Profile: http://www.excelforum.com/member.php...fo&userid=3014
View this thread: http://www.excelforum.com/showthread.php?threadid=49828