cell formatting

J

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?
 
C

Carim

Hi James,

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