thank you for the suggestions. I still find it odd that the format of the cell would override its value.