Hi
seeing the real sheet ( not a picture) would be a great help.
Be aware that formatting dos not change underlying values, it is just the way XL shows things to the outside world.
This being said be also aware that in a comparison, text is ALWAYS larger than any number. If you can provide the sheet, I will explain why. and text is always left aligned in a cell when no manual alignment has been applied even if it looks like a number)

__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post