Hi,

Not sure how you went about converting them to text, but the value in B1 is still a number.

What method did you employ?

Regards