Excel is not working as advertised, really take a look.

OK folks, I attached the excel file and a snap shot of what it looks like on my screen. I'm no expert, but where I have the =$B$8 shown in the snapshot, it should read AU like it does in cell B8. This program is doing this kind of stuff to me all the time.

How can I get the software to work correctly. Excel is the only software product that I have witnessed this on my computer. With all the other software options I own and use on this particular computer, I have no issues. Is there a special setting that I need to click or unclick. You know a check box that says excel is f-ing with me?