Hi mryan,

Welcome to the forum.

Commenting anything without seeing the spreadsheet will not help... may be custom formatting or some formulation or through vb code anything could be a reason for that, suggest you to upload that file / that sheet tab. Thanks.

Regards,
DILIPandey

<click on below 'star' if this helps>