View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.newusers
SHEARER SHEARER is offline
external usenet poster
 
Posts: 3
Default how to change from dollars to pounds in a balance sheet

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?