View Single Post
  #7   Report Post  
Posted to microsoft.public.excel.newusers
Gord Dibben Gord Dibben is offline
external usenet poster
Posts: 22,906
Default how to change from dollars to pounds in a balance sheet

Good to hear.

Thanks for the feedback.


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

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

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