Home |
Search |
Today's Posts |
#1
|
|||
|
|||
cell will not center
Hi.
I have a user with an Excel worksheet. There are multiple rows and columns and they are all set on center alignment, (center alignment icon on the toolbar as well as Format Cells -- Horizontal Alignment -- Center.) The alphabetical characters align correctly but the numerical don't, as they will only left align. Format Cells -- Number is set to General, so I don't know why it won't change the alignment. Other than the worksheet being corrupted, I don't know what could be wrong with it. Any suggestions are much appreciated. Thanks! Hilary |
#2
|
|||
|
|||
?B?SGlsYXJ5?= wrote in
: Hi. I have a user with an Excel worksheet. There are multiple rows and columns and they are all set on center alignment, (center alignment icon on the toolbar as well as Format Cells -- Horizontal Alignment -- Center.) The alphabetical characters align correctly but the numerical don't, as they will only left align. Do you see (in the formula bar) an apostrophe ' before these numbers? -- It is I, DeauDeau (Free after monsieur Leclerc in 'Allo, 'allo) |
#3
|
|||
|
|||
Nope. No apostrophe.
"Dodo" wrote: ?B?SGlsYXJ5?= wrote in : Hi. I have a user with an Excel worksheet. There are multiple rows and columns and they are all set on center alignment, (center alignment icon on the toolbar as well as Format Cells -- Horizontal Alignment -- Center.) The alphabetical characters align correctly but the numerical don't, as they will only left align. Do you see (in the formula bar) an apostrophe ' before these numbers? -- It is I, DeauDeau (Free after monsieur Leclerc in 'Allo, 'allo) |
#4
|
|||
|
|||
?B?SGlsYXJ5?= wrote in
: Nope. No apostrophe. The only other thing I can think of giving this result, is when the "numbers" are followed by spaces. This you can check too in the formula bar. -- It is I, DeauDeau (Free after monsieur Leclerc in 'Allo, 'allo) |
#5
|
|||
|
|||
Is the user using Excel for the worksheet, or a viewer of some form? Can the user, in another cell, put =A1+1 (where A1 is replaced with address of one of the offending cells) Does the offending cell show the data to the left and double width, as it would be if Alt/Enter were used in the cell? Are there any other clues, such as what happens if you re-enter the number in the cell? (you can Ctrl/Z to un-enter that) Dodo Wrote: ?B?SGlsYXJ5?= wrote in : Nope. No apostrophe. The only other thing I can think of giving this result, is when the "numbers" are followed by spaces. This you can check too in the formula bar. -- It is I, DeauDeau (Free after monsieur Leclerc in 'Allo, 'allo) -- Bryan Hessey ------------------------------------------------------------------------ Bryan Hessey's Profile: http://www.excelforum.com/member.php...o&userid=21059 View this thread: http://www.excelforum.com/showthread...hreadid=395199 |
#6
|
|||
|
|||
Quote:
Did you previously set those cells to "Comma Style"? If you look next to the icon for "Currency Style", you've got "Percentage", "Comma" and "Add/Remove Decimal Place". Once you've set a cell to Currency or Comma Style, even removing the decimal places leaves that style set, and sets an invisible 'decimal tab' point. Try going to Format -- Cells -- Number Then, select Category as 'Number' and set the required number of decimal places. This may fix it. Regards, BizMark |
#7
|
|||
|
|||
Is the cell part of a merged area? (maybe it's centered in those cells that are
merged?) Has the cell been part of multiple cells that were formatted via: cells|format|alignment tab|horizontal text alignment box: Center across Selection I remember having trouble turning that off in earlier versions and keeping alignment the way I wanted. Are you sure that the cell is really formatted as general: select the cell hit alt-f11 (to get to the VBE) hit ctrl-g (to see the immediate window) type this: ?activecell.numberformat do you get: General returned? Hilary wrote: Hi. I have a user with an Excel worksheet. There are multiple rows and columns and they are all set on center alignment, (center alignment icon on the toolbar as well as Format Cells -- Horizontal Alignment -- Center.) The alphabetical characters align correctly but the numerical don't, as they will only left align. Format Cells -- Number is set to General, so I don't know why it won't change the alignment. Other than the worksheet being corrupted, I don't know what could be wrong with it. Any suggestions are much appreciated. Thanks! Hilary -- Dave Peterson |
#8
|
|||
|
|||
Hi Dave.
No, it's not part of a merged area nor has the cell been part of multiple cells that were formatted as you described. And finally, I entered ?activecell.numberformat and got "general." I'm stumped! Hilary "Dave Peterson" wrote: Is the cell part of a merged area? (maybe it's centered in those cells that are merged?) Has the cell been part of multiple cells that were formatted via: cells|format|alignment tab|horizontal text alignment box: Center across Selection I remember having trouble turning that off in earlier versions and keeping alignment the way I wanted. Are you sure that the cell is really formatted as general: select the cell hit alt-f11 (to get to the VBE) hit ctrl-g (to see the immediate window) type this: ?activecell.numberformat do you get: General returned? Hilary wrote: Hi. I have a user with an Excel worksheet. There are multiple rows and columns and they are all set on center alignment, (center alignment icon on the toolbar as well as Format Cells -- Horizontal Alignment -- Center.) The alphabetical characters align correctly but the numerical don't, as they will only left align. Format Cells -- Number is set to General, so I don't know why it won't change the alignment. Other than the worksheet being corrupted, I don't know what could be wrong with it. Any suggestions are much appreciated. Thanks! Hilary -- Dave Peterson |
#9
|
|||
|
|||
Hi Bryan.
The user is using Excel for the worksheet. When I put =A1+1 (replacing with the offending cell), it does not add the two numbers. Finally, nothing different happens when I re-enter a number in the offending cell. However, cells with alphabetical text do center properly. Any other thoughts? Hilary "Bryan Hessey" wrote: Is the user using Excel for the worksheet, or a viewer of some form? Can the user, in another cell, put =A1+1 (where A1 is replaced with address of one of the offending cells) Does the offending cell show the data to the left and double width, as it would be if Alt/Enter were used in the cell? Are there any other clues, such as what happens if you re-enter the number in the cell? (you can Ctrl/Z to un-enter that) Dodo Wrote: ?B?SGlsYXJ5?= wrote in : Nope. No apostrophe. The only other thing I can think of giving this result, is when the "numbers" are followed by spaces. This you can check too in the formula bar. -- It is I, DeauDeau (Free after monsieur Leclerc in 'Allo, 'allo) -- Bryan Hessey ------------------------------------------------------------------------ Bryan Hessey's Profile: http://www.excelforum.com/member.php...o&userid=21059 View this thread: http://www.excelforum.com/showthread...hreadid=395199 |
#10
|
|||
|
|||
Hi Bryan.
The user is using Excel for the worksheet. When I put =A1+1 (replacing with the offending cell), it does not add the two numbers. Finally, nothing different happens when I re-enter a number in the offending cell. However, cells with alphabetical text do center properly. Any other thoughts? Hilary "Bryan Hessey" wrote: Is the user using Excel for the worksheet, or a viewer of some form? Can the user, in another cell, put =A1+1 (where A1 is replaced with address of one of the offending cells) Does the offending cell show the data to the left and double width, as it would be if Alt/Enter were used in the cell? Are there any other clues, such as what happens if you re-enter the number in the cell? (you can Ctrl/Z to un-enter that) Dodo Wrote: ?B?SGlsYXJ5?= wrote in : Nope. No apostrophe. The only other thing I can think of giving this result, is when the "numbers" are followed by spaces. This you can check too in the formula bar. -- It is I, DeauDeau (Free after monsieur Leclerc in 'Allo, 'allo) -- Bryan Hessey ------------------------------------------------------------------------ Bryan Hessey's Profile: http://www.excelforum.com/member.php...o&userid=21059 View this thread: http://www.excelforum.com/showthread...hreadid=395199 |
#11
|
|||
|
|||
Hi BizMark.
As far as I know, no one has set the cells to comma style. Hilary "BizMark" wrote: Dodo Wrote: ?B?SGlsYXJ5?= wrote in : - Nope. No apostrophe. - The only other thing I can think of giving this result, is when the "numbers" are followed by spaces. This you can check too in the formula bar. -- It is I, DeauDeau (Free after monsieur Leclerc in 'Allo, 'allo) Did you previously set those cells to "Comma Style"? If you look next to the icon for "Currency Style", you've got "Percentage", "Comma" and "Add/Remove Decimal Place". Once you've set a cell to Currency or Comma Style, even removing the decimal places leaves that style set, and sets an invisible 'decimal tab' point. Try going to Format -- Cells -- Number Then, select Category as 'Number' and set the required number of decimal places. This may fix it. Regards, BizMark -- BizMark |
#12
|
|||
|
|||
Nope, no spaces either.
"Dodo" wrote: ?B?SGlsYXJ5?= wrote in : Nope. No apostrophe. The only other thing I can think of giving this result, is when the "numbers" are followed by spaces. This you can check too in the formula bar. -- It is I, DeauDeau (Free after monsieur Leclerc in 'Allo, 'allo) |
#13
|
|||
|
|||
I don't have another guess.
Sorry. Hilary wrote: Hi Dave. No, it's not part of a merged area nor has the cell been part of multiple cells that were formatted as you described. And finally, I entered ?activecell.numberformat and got "general." I'm stumped! Hilary "Dave Peterson" wrote: Is the cell part of a merged area? (maybe it's centered in those cells that are merged?) Has the cell been part of multiple cells that were formatted via: cells|format|alignment tab|horizontal text alignment box: Center across Selection I remember having trouble turning that off in earlier versions and keeping alignment the way I wanted. Are you sure that the cell is really formatted as general: select the cell hit alt-f11 (to get to the VBE) hit ctrl-g (to see the immediate window) type this: ?activecell.numberformat do you get: General returned? Hilary wrote: Hi. I have a user with an Excel worksheet. There are multiple rows and columns and they are all set on center alignment, (center alignment icon on the toolbar as well as Format Cells -- Horizontal Alignment -- Center.) The alphabetical characters align correctly but the numerical don't, as they will only left align. Format Cells -- Number is set to General, so I don't know why it won't change the alignment. Other than the worksheet being corrupted, I don't know what could be wrong with it. Any suggestions are much appreciated. Thanks! Hilary -- Dave Peterson -- Dave Peterson |
#14
|
|||
|
|||
?B?SGlsYXJ5?= wrote in
: Hi Bryan. The user is using Excel for the worksheet. When I put =A1+1 (replacing with the offending cell), it does not add the two numbers. Doesn't that indicate that the offending cell's format is not number?! What do you get as a result of this formula? Does this all happen only on the user's puter or also on other machines when you copy the spreadsheet there? -- It is I, DeauDeau (Free after monsieur Leclerc in 'Allo, 'allo) |
#15
|
|||
|
|||
?B?SGlsYXJ5?= wrote in
: Nope, no spaces either. You're not by any chance using a right-to-left capable OS? http://support.microsoft.com/default...3467#appliesto Or macros/VBA running in the background doing things? Or designed the worksheet in one Excel version and saved/use it in a different version? What version is being used? What else is typical for that particular spreadsheet/work environment? What does MS have to say about it? ;-))) -- It is I, DeauDeau (Free after monsieur Leclerc in 'Allo, 'allo) |
#16
|
|||
|
|||
Thanks for your help. We've decided to just call it a currupted file and copy
and paste into a new worksheet. Thanks though! Hilary "Dodo" wrote: ?B?SGlsYXJ5?= wrote in : Nope, no spaces either. You're not by any chance using a right-to-left capable OS? http://support.microsoft.com/default...3467#appliesto Or macros/VBA running in the background doing things? Or designed the worksheet in one Excel version and saved/use it in a different version? What version is being used? What else is typical for that particular spreadsheet/work environment? What does MS have to say about it? ;-))) -- It is I, DeauDeau (Free after monsieur Leclerc in 'Allo, 'allo) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
copying cell names | Excel Discussion (Misc queries) | |||
Cell color based upon cell value | Excel Discussion (Misc queries) | |||
cell color index comparison | New Users to Excel | |||
Cell Change Color - Need Help | New Users to Excel | |||
VLookup resulting in a blank cell... | Excel Worksheet Functions |