Centered Horizontal Text Alignment displaying incorrectly

[AnthonyA755]

Hi, I'm absolutely stuck on how to fix this. I have a spreadsheet which I use to print labels and a VBA macro that takes a list of names from another workbook and inputs into my label template. This all works fine (I dont think my macro is the issue anyway, i still have the same problem when manually typing data into my spreadsheet). The issue I am having is that the cell's horizontal text alignment isn't perfectly centered, however when I click into the cell, it is. I have included two example images below - as you can see, the text correctly displays as centered only when i click into it. This is extremely frustrating, does anyone know what I can do to fix this?

Thank you in advance!

 

[Rybeliaz]

Hi, I'm absolutely stuck on how to fix this. I have a spreadsheet which I use to print labels and a VBA macro that takes a list of names from another workbook and inputs into my label template. This all works fine (I dont think my macro is the issue anyway, i still have the same problem when manually typing data into my spreadsheet). The issue I am having is that the cell's horizontal text alignment isn't perfectly centered, however when I click into the cell, it is. I have included two example images below - as you can see, the text correctly displays as centered only when i click into it. This is extremely frustrating, does anyone know what I can do to fix this?

Thank you in advance!

View attachment 101795

View attachment 101796

I world like to know how to do this as well