Hi,

I have a problem with the number format in excel. When a number is
entered in cell A1 and in cell B1 =A1 is entered, the number format of
cell A1 is taken over in cell B1. If afterwards the number format in
cell A1 is changed, this new number format will not be taken over in
cell B1. Is there a possibility to automatically take over the changed
number format in cell B1 ?

Thank you in advance.


--
Ivan
------------------------------------------------------------------------
Ivan's Profile: http://www.excelforum.com/member.php...o&userid=27997
View this thread: http://www.excelforum.com/showthread...hreadid=474989