Making the text in a cell with a money format centered

[Wombat]

Is this possible? I've tried but the text in the cell always sticks to the
right...

 

[trip_to_tokyo]

Yes.

In EXCEL 2007 for cell D4:-

1. Right hand click in cell and select Format Cells.

2. Format Cells should launch.

3. Number tab / Currency setting on left hand side / set Symbol: to $
English (United States) / OK

4. Enter 100 into the cell so that it appears as follows:-

$100.00

5. Home / Alignment group / Center

Cell D 4 is correctly centred.

Please hit Yes if my comments have helped.

Thanks.

 

[Wombat]

Excel 2003 I'm afraid!

Yes.

In EXCEL 2007 for cell D4:-

1. Right hand click in cell and select Format Cells.

2. Format Cells should launch.

3. Number tab / Currency setting on left hand side / set Symbol: to $
English (United States) / OK

4. Enter 100 into the cell so that it appears as follows:-

$100.00

5. Home / Alignment group / Center

Cell D 4 is correctly centred.

Please hit Yes if my comments have helped.

Thanks.

 

[trip_to_tokyo]

Should still be something very similar.

Excel 2003 I'm afraid!

 

[Fred Smith]

It's on the Alignment tab of the Format Cells dialogue box.

In the future, tell us what you tried, and your version of Excel.

Regards,
Fred

 

[Gord Dibben]

If it is Accounting Format you cannot center it.

If Currency Format go ahead and center it via
Format>Cells>Aignment>Hozizontal>Center.


Gord Dibben MS Excel MVP