Is the STOCK() function broken?

I am seeing the price displaying in what appears to be a left-justified text format. Any calculations using it are evaluating as zero. The sheet is already shared if someone wants to look at it.
Robert