i am trying to set up a balance sheet but the currency is set up for dollars
and i want to use pounds,someone said go to format-cells(but cells is not
highlighted so i cannot click on it-they also said click on top lhs and it
would go black-but it does not)
any ideas please?

You can change the Currency Icon ($) by doing the following: Go to the
format menu and select Style... Choose Currency from the Style name: dropdown
box; choose the modify button and select English(United Kingdom) from the
Symbol: dropdown box. Select ok. You use the icon the same way....click on
the cell you want to format and then click the Currency Icon ($)

"SHEARER" wrote:

i am trying to set up a balance sheet but the currency is set up for dollars
and i want to use pounds,someone said go to format-cells(but cells is not
highlighted so i cannot click on it-they also said click on top lhs and it
would go black-but it does not)
any ideas please?

the only thing is that style is not highlighted so i cannot click on it?

"sjk153" wrote:

You can change the Currency Icon ($) by doing the following: Go to the
format menu and select Style... Choose Currency from the Style name: dropdown
box; choose the modify button and select English(United Kingdom) from the
Symbol: dropdown box. Select ok. You use the icon the same way....click on
the cell you want to format and then click the Currency Icon ($)

"SHEARER" wrote:

i am trying to set up a balance sheet but the currency is set up for dollars
and i want to use pounds,someone said go to format-cells(but cells is not
highlighted so i cannot click on it-they also said click on top lhs and it
would go black-but it does not)
any ideas please?

I would suggest that you worksheet is protected if you cannot access these
features like FormatCells and FormatStyle

Go to ToolsProtection and see if "Unprotect sheet" is available.

You may have to supply a password.


Gord Dibben MS Excel MVP

On Mon, 2 Oct 2006 11:13:02 -0700, SHEARER
wrote:

the only thing is that style is not highlighted so i cannot click on it?

"sjk153" wrote:

You can change the Currency Icon ($) by doing the following: Go to the
format menu and select Style... Choose Currency from the Style name: dropdown
box; choose the modify button and select English(United Kingdom) from the
Symbol: dropdown box. Select ok. You use the icon the same way....click on
the cell you want to format and then click the Currency Icon ($)

"SHEARER" wrote:

i am trying to set up a balance sheet but the currency is set up for dollars
and i want to use pounds,someone said go to format-cells(but cells is not
highlighted so i cannot click on it-they also said click on top lhs and it
would go black-but it does not)
any ideas please?

Thank you it was protected and all ok now.

"Gord Dibben" wrote:

I would suggest that you worksheet is protected if you cannot access these
features like FormatCells and FormatStyle

Go to ToolsProtection and see if "Unprotect sheet" is available.

You may have to supply a password.


Gord Dibben MS Excel MVP

On Mon, 2 Oct 2006 11:13:02 -0700, SHEARER
wrote:

the only thing is that style is not highlighted so i cannot click on it?

"sjk153" wrote:

You can change the Currency Icon ($) by doing the following: Go to the
format menu and select Style... Choose Currency from the Style name: dropdown
box; choose the modify button and select English(United Kingdom) from the
Symbol: dropdown box. Select ok. You use the icon the same way....click on
the cell you want to format and then click the Currency Icon ($)

"SHEARER" wrote:

i am trying to set up a balance sheet but the currency is set up for dollars
and i want to use pounds,someone said go to format-cells(but cells is not
highlighted so i cannot click on it-they also said click on top lhs and it
would go black-but it does not)
any ideas please?

Good to hear.

Thanks for the feedback.


Gord

On Tue, 3 Oct 2006 02:50:01 -0700, SHEARER
wrote:

Thank you it was protected and all ok now.

"Gord Dibben" wrote:

I would suggest that you worksheet is protected if you cannot access these
features like FormatCells and FormatStyle

Go to ToolsProtection and see if "Unprotect sheet" is available.

You may have to supply a password.


Gord Dibben MS Excel MVP

On Mon, 2 Oct 2006 11:13:02 -0700, SHEARER
wrote:

the only thing is that style is not highlighted so i cannot click on it?

"sjk153" wrote:

You can change the Currency Icon ($) by doing the following: Go to the
format menu and select Style... Choose Currency from the Style name: dropdown
box; choose the modify button and select English(United Kingdom) from the
Symbol: dropdown box. Select ok. You use the icon the same way....click on
the cell you want to format and then click the Currency Icon ($)

"SHEARER" wrote:

i am trying to set up a balance sheet but the currency is set up for dollars
and i want to use pounds,someone said go to format-cells(but cells is not
highlighted so i cannot click on it-they also said click on top lhs and it
would go black-but it does not)
any ideas please?



Gord Dibben MS Excel MVP

Sure, I can help you with that! Here are the steps to change the currency from dollars to pounds in a balance sheet in Microsoft Excel:

1. Select the cells that you want to change the currency format for. You can do this by clicking and dragging your mouse over the cells, or by clicking on the first cell and then holding down the Shift key while clicking on the last cell.
2. Right-click on the selected cells and choose "Format Cells" from the context menu.
3. In the Format Cells dialog box, click on the "Number" tab.
4. In the "Category" list, select "Currency".
5. In the "Symbol" list, select "English (United Kingdom)".
6. In the "Decimal places" box, enter the number of decimal places you want to display for the currency.
7. Click "OK" to apply the changes.

That's it! Your balance sheet should now display the currency in pounds instead of dollars. If you have any other questions or need further assistance, feel free to ask.