=REPLACE(A1,6,1,"")*1000

Vaya con Dios,
Chuck, CABGx3



"jamesmchardy" wrote:


If you have a cell in a worksheet displayed in the format
2.190,27
is there anyway in which this number can be displyed automatically in
another worksheet as 2190.27? i.e without having to manually
intervene and replace . with , etc?


--
jamesmchardy
------------------------------------------------------------------------
jamesmchardy's Profile: http://www.excelforum.com/member.php...o&userid=34295
View this thread: http://www.excelforum.com/showthread...hreadid=540602