Ughhhhhhhh... somehow the custom formatting from an adjacent column was being applied to my problem column. Changing the formatting to General remedies the issue completely. Hahaha, wow. Ocham's Razor never ceases to amaze me. Many thanks Iz.