Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old September 12th 06, 10:20 PM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Sep 2006
Posts: 119
Default Cell won't center contents

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

  #2   Report Post  
Old September 12th 06, 10:25 PM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
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

  #3   Report Post  
Old September 12th 06, 10:39 PM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Sep 2006
Posts: 119
Default Cell won't center contents

None. Each of these cells contains a single digit and I've even retyped them
all to make sure.
--
Steve C


"tim m" wrote:

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

  #4   Report Post  
Old September 12th 06, 11:25 PM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 35,218
Default Cell won't center contents

Try formatting the cell as General.

An accounting format (or clicking the Currency icon) could cause this trouble.

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


--

Dave Peterson


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Help with this conditional IF statement C-Dawg Excel Discussion (Misc queries) 3 May 15th 06 06:01 PM
Conversion of Cell Contents into a Functional Worksheet name ? GMJT Excel Worksheet Functions 1 August 21st 05 04:59 PM
Copy cell format to cell on another worksht and update automatical kevinm Excel Worksheet Functions 21 May 19th 05 11:07 AM
Function syntax to compare cell contents ES Excel Worksheet Functions 2 May 18th 05 03:53 PM
GET.CELL Biff Excel Worksheet Functions 2 November 24th 04 08:16 PM


All times are GMT +1. The time now is 01:59 AM.

Powered by vBulletin® Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
Copyright 2004-2019 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017