I have the following formula that I am practicing/experimenting with in, say, cell F15:
=SUM(INDEX(C10:D16,2,2):INDEX(C10:D16,4,2))
Column C contains valid dates, column D contains numbers.
Whenever I change F15, say the 4,2 -> 5,2, the format of cell F15 reverts to "dates" no matter how I have previously formatted it.
What is happening?
I would say that Excel is looking in column C first, where the dates are and interpreting the formula to date format.
Just to check that, if you format the dates to General, then change the 4,2 to 5,2 it works fine.
oldchippy
-------------
Blessed are those who can give without remembering and take without forgetting
If you are happy with the help you have received, please click the <--- STAR icon on the left - Thanks.
Click here >>> Top Excel links for beginners to Experts
Forum Rules >>>Please don't forget to read these
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks