| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
number format
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Number format exactly the same, displays differently in some cells | Excel Discussion (Misc queries) | |||
| Number format for Combobox | Excel Discussion (Misc queries) | |||
| I want to format a number cell without the decimal and without ro. | Excel Discussion (Misc queries) | |||
| 16 digit number wont keep alteration unless format cell to text | Excel Discussion (Misc queries) | |||
| How do i change numbers in text format to number format? | New Users to Excel | |||
Threaded Mode
