View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
tim m tim m is offline
external usenet poster
 
Posts: 430
Default Cell won't center contents

No leading or following spaces I take it?

"Steve C" wrote:

Our company has a spreadsheet containing several columns of information in a
data list. A handful of cells within these columns absolutely baffle me by
not allowing any changes to alignment (left, center or right) whatsoever.
These cells all contain single digit numbers that remain left-aligned no
matter what I've tried (we need them centered). There is no protection on
any of these cells or the entire sheet or workbook, and these cells are
formatted exactly the same as others that do allow alignment changes. None
of the cells are merged with any others.

I'm an advanced Excel user, but this one has me scratching my head. Thanks
for any suggestions!
--
Steve C