Bizarre Excel Mystery!!

[Julie P.]

Please take a look at my screen shot:

http://home.comcast.net/~jporpiglia/best-buy/best-buy-screen.gif

Look at cells B6 and B7. They are both centered. The contents are identical
lengths, yet the contents of one is to the left of the other. Why is it
doing this?? this is driving me nuts!!

Thanks for any help!

Julie

 

[Julie P.]

Please take a look at my screen shot:

http://home.comcast.net/~jporpiglia/best-buy/best-buy-screen.gif

Look at cells B6 and B7. They are both centered. The contents are
identical lengths, yet the contents of one is to the left of the other.
Why is it doing this?? this is driving me nuts!!

Thanks for any help!

Julie

Oh duh!! Never mind! There was a space after the last character in one of
the cells!

 

[Bob Umlas]

Make sure the formatting is the same -- click on B6, click the Format
Painter tool ((ight under the Data menu), then Clicl B7. Shuld be OK.

Bob Umlas
Excel MVP

 

[Bill Sharpe]

The real mystery is what happened to cells b6 and b7 in your screen
shot. Column B is hidden.

Bill
PS Glad you solved this mysterious problem, anyway!

Please take a look at my screen shot:

http://home.comcast.net/~jporpiglia/best-buy/best-buy-screen.gif

Look at cells B6 and B7. They are both centered. The contents are
identical lengths, yet the contents of one is to the left of the
other.
Why is it doing this?? this is driving me nuts!!

Thanks for any help!

Julie

Oh duh!! Never mind! There was a space after the last character in one
of
the cells!