I loaded the subject yesterday and now substantial portions of my
soreadsheets are not functioning. As far as I can tell at this point, one
problem
revolves upon VLOOKUP and HLOOKUP functions are bringing numeric values as
text, in that arithmetic functions on them yield "#VALUE". When I manually
re-enter the value the arithmetic is carried out OK. The VLOOKUP and
HLOOKUP are functioning correctly insofar as bringing in correct values. I
have
attempted a Paste Special of the values, de-selecting Text and selecting
Numbers to no avail. If I can't find a remedy, I will have to revert to Excel.
I also have found OO3.2 and Excel to be incompatable maminly, I think, due
to one using semicolon (";") delimiters and the other using colons (",").
Yout thoughts on this will be appreciated. jreyr--
-----------------------------------------------------------------
To unsubscribe send email to [email protected]
For additional commands send email to [email protected]
with Subject: help
