software

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: www.excelforum.com/member.php...oamp;userid=34295
View this thread: www.excelforum.com/showthread...hreadid=540602Hi James,

Are you 100% sure that the first cell is indeed a number: 2.190,27 ...
Carim=REPLACE(A1,6,1,quot;quot;)*1000

Vaya con Dios,
Chuck, CABGx3
quot;jamesmchardyquot; wrote:

gt;
gt; If you have a cell in a worksheet displayed in the format
gt; 2.190,27
gt; is there anyway in which this number can be displyed automatically in
gt; another worksheet as 2190.27? i.e without having to manually
gt; intervene and replace . with , etc?
gt;
gt;
gt; --
gt; jamesmchardy
gt; ------------------------------------------------------------------------
gt; jamesmchardy's Profile: www.excelforum.com/member.php...oamp;userid=34295
gt; View this thread: www.excelforum.com/showthread...hreadid=540602
gt;
gt;