Thread: cell formatting
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
jamesmchardy
 
Posts: n/a
Default cell formatting


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