| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Offset function not working correctly
I have a series of spreadsheets in one workbook that are linked to another
workbook. My formulas are written as follows: =OFFSET('[INVWKSH09.xls]2001'!$A$236,5,3) When I change the formula to make the offset change, for example changing the 5 in the above formula to a 6, then the formatting is changed from numerical to date. Once I re-format the woprksheets to numerical, then my numbers appear and have changed to what they should be. My question is why the formatting is changing? -- Allan |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Offset function not working correctly
I'd -*guess *-that D242 has a date format in it and Excel is trying to be helpful! -- p45cal *p45cal* ------------------------------------------------------------------------ p45cal's Profile: http://www.thecodecage.com/forumz/member.php?userid=558 View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=126826 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Fill down function not working correctly and producing weird resul | Excel Worksheet Functions | |||
| Subtotal function is not working correctly | Excel Discussion (Misc queries) | |||
| Autofilter not working correctly... | Excel Discussion (Misc queries) | |||
| Lookup function still not working correctly | Excel Worksheet Functions | |||
| Sum function not working correctly in Excel (Skips Cell) | Excel Worksheet Functions | |||
Linear Mode
