It is formatted to 0.0%, so I enter the daily change. it worked just like I wanted for a year.
Until a couple days ago if the market went up .4% I would enter .4 and all would be well. Now it suddenly interprets .4 as 40%! I can get .4% by entering .004, 0.4, or even .4%; just not by .4.
What on earth is going on? Is there anyway to made it do what I want (ie. what it used to do...)
I am beginning to fear early onset dementia.
Okay, it is Excel97 if that matters. It does everything I want (well up to a couple days ago) so why change.