cell formatting

[jamesmchardy]

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?

[Carim]

Hi James,

Are you 100% sure that the first cell is indeed a number: 2.190,27 ...
Carim

[CLR]

=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
>
>