Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Whenever I use formulas in lookup functions (v-lookup, h-lookup and index),
then I save the spreadsheet and close it, when I open the file again, MS imbeds in my lookup functions formula +1-1. This is added each time I save and close. I could end up having many +1-1's and eventually causes an error in the program. If I use regular numbers, i.e. 1, 4, 8, the +1-1 does not occur. I am using Microsoft Works 8.0. What's going on??? -- cityboyjerry |