Cell Formating- Why won't my data center
 

I have copied some data from one spread sheet to another. When I try to
center the data, the command does not execute. I have formated it as a
currency. Any ideas?
Thanks.

Cell Formating- Why won't my data center
 

WesleyL wrote:
I have copied some data from one spread sheet to another. When I try to
center the data, the command does not execute. I have formated it as a
currency. Any ideas?
Thanks.

This might work for you. Select the problem cells. In the Format | Cells
| Number dialog, switch to Custom. It will look something like this:

_($* #,##0.00_);_($* (#,##0.00);_($* "-"??_);_(@_)
^^ ^^ ^^

Delete the asterisk-space pairs.

More learning he
http://office.microsoft.com/en-us/ex...986791033.aspx
("Repeating characters" section)