Currency format won't centre

  • Thread starter Thread starter Deborah
  • Start date Start date
D

Deborah

I have totals formatted as currency, no decimal positions. However, I
cannot centre them too. Any ideas?
Using Excel XP.
Deborah
 
Hi Deborah,

You should be able to center the cell via
Format>Cells>, click the Alignment Tab, and choose Center in the Horizontal
box

--

Kind Regards,

Niek Otten

Microsoft MVP - Excel
 
Niek Otten said:
Hi Deborah,
Click to expand...
Yes I should be able too. But this way or on toolbar has no effect on
my cell. I have also done a Clear Formatting to make sure there is
nothing else attached from previous users and reapplied Currency then
Centre. A few files will not let me centre them and other files work
fine.

It is buggy to say the least.
Deborah
 
Back
Top