J
James Silverton
I am not particularly proud of solving this problem and I am even a little
ashamed of needing to! However, I was certainly puzzled for a while.
I set up a new workbook with a rather large amount of downloaded data. The
first things I wanted were the maximum and minimum in a column. MAX: no
problem but MIN prompted me for a single value! After a little while it
became apparent that somehow I was getting the MINUTE function when I asked
for MIN! After checking a new workbook which worked properly, I thought to
look at autocomplete and there it was: "min" was completed to "minute"!
What had happened was that I had copied a small amount of text from a Word
document for a comment at the head of the sheet and the autocompletion
settings were also copied! Of course, Paste Special in text mode was what I
should have done!
ashamed of needing to! However, I was certainly puzzled for a while.
I set up a new workbook with a rather large amount of downloaded data. The
first things I wanted were the maximum and minimum in a column. MAX: no
problem but MIN prompted me for a single value! After a little while it
became apparent that somehow I was getting the MINUTE function when I asked
for MIN! After checking a new workbook which worked properly, I thought to
look at autocomplete and there it was: "min" was completed to "minute"!
What had happened was that I had copied a small amount of text from a Word
document for a comment at the head of the sheet and the autocompletion
settings were also copied! Of course, Paste Special in text mode was what I
should have done!