Data Not Overlapping Next Cell

[kruegs35]

This is probably a simple fix, but I cannot figure out why some of my data will overlap over the next cell if it is bigger than the cell width and then some will not, I just get ###### error. There is nothing in the next cell. I don't want to increase the cell size because that would mess up the rest of my page format. I've also tried to merge two cells together, but then it causes an error in my macro, even though the cell name is the same.

[Macropheliac]

Try selecting the cells and setting the Alignment property to CenterAcrossSelection.

[kruegs35]

CenterAcrossSelection did not work. I found out that numbers do not overlap, but text does. In these particular cells, I put in ID numbers so they usually have some text in them and are not a problem. In the rare event I have just a number I will have to remember to use a ' in front. I guess I will just have to use this solution for now.