So, I developed some gauge tables a while back and it was recently pointed out to me that the K factors in the tables aren't being used by solidworks.  It is constantly reverting to .5 (default).  I have verified this action with some .net code.  Has anyone had this problem before?  How do you fix it?

.

The k factor that should be used (circled in red):

K factor being used (verified with vb.net)

Perhaps the cells in my spreadsheet are not formatted correctly?  I've tried text, number 2 place, number 4 place.  What else?

Jason