Cell Formating- Why won't my data center

W

WesleyL

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.
 
S

smartin

WesleyL said:
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.
Click to expand...

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 here:
http://office.microsoft.com/en-us/excel/HP051986791033.aspx
("Repeating characters" section)
 
Top