Prev: Sum if a cell is not a certain data
Next: AUTO-POPULATE WORKBOOK WHEN OTHER WORKBOOKS ARE CHANGED
From: Wombat on 10 Feb 2010 10:46
Is this possible? I've tried but the text in the cell always sticks to the
right...
From: trip_to_tokyo on 10 Feb 2010 11:01
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" wrote:

> Is this possible? I've tried but the text in the cell always sticks to the
> right...
From: Wombat on 10 Feb 2010 11:05
Excel 2003 I'm afraid!

"trip_to_tokyo" wrote:

> 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" wrote:
>
> > Is this possible? I've tried but the text in the cell always sticks to the
> > right...
From: trip_to_tokyo on 10 Feb 2010 11:26
Should still be something very similar.

"Wombat" wrote:

> Excel 2003 I'm afraid!
>
> "trip_to_tokyo" wrote:
>
> > 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" wrote:
> >
> > > Is this possible? I've tried but the text in the cell always sticks to the
> > > right...
From: Fred Smith on 10 Feb 2010 11:44
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

"Wombat" <Wombat(a)discussions.microsoft.com> wrote in message
news:7B4764BA-FC9A-4A9E-B0AC-E4C0C84D6B4A(a)microsoft.com...
> Is this possible? I've tried but the text in the cell always sticks to the
> right...

 |  Next  |  Last
Pages: 1 2
Prev: Sum if a cell is not a certain data
Next: AUTO-POPULATE WORKBOOK WHEN OTHER WORKBOOKS ARE CHANGED