| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Making cell reference absolute makes cell format text
Hi
Weird one here! I've been browsing the Excel forums for years and not seen this. One sheet is called Special One Off Deals, and in cell C2 is Aug 06 - formatted as text. In another sheet, any General cell, I type = and then navigate to C2 in the other sheet and hit enter. The result is Aug 06 - formatted as text. That's fine - and as a result the cell format changes to text (which I didn't expect). I now edit the cell and change the reference to absolute (ie ='Special One Off Deals'!$C$2 ) and now the formula displays in the cell - not the result. Why? I have tried it on two different PCs and get the same each time. It's got me beat! Cheers. Andy. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Maintaining cell reference after sorting | Excel Discussion (Misc queries) | |||
| cell reference changes and conditional formatting | Excel Worksheet Functions | |||
| Custom functions calculating time arguments Help Desperate | Excel Worksheet Functions | |||
| Bring the cell format along with the cell value from a reference c | Excel Worksheet Functions | |||
| Possible Lookup Table | Excel Worksheet Functions | |||
Threaded Mode
