Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old October 2nd 06, 06:47 PM posted to microsoft.public.excel.newusers
external usenet poster
 
First recorded activity by ExcelBanter: Oct 2006
Posts: 3
Default how to change from dollars to pounds in a balance sheet

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?

  #2   Report Post  
Old October 2nd 06, 07:01 PM posted to microsoft.public.excel.newusers
external usenet poster
 
First recorded activity by ExcelBanter: Sep 2006
Posts: 13
Default how to change from dollars to pounds in a balance sheet

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?

  #3   Report Post  
Old October 2nd 06, 07:13 PM posted to microsoft.public.excel.newusers
external usenet poster
 
First recorded activity by ExcelBanter: Oct 2006
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?

  #4   Report Post  
Old October 2nd 06, 08:36 PM posted to microsoft.public.excel.newusers
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 22,909
Default how to change from dollars to pounds in a balance sheet

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?


  #5   Report Post  
Old October 3rd 06, 10:50 AM posted to microsoft.public.excel.newusers
external usenet poster
 
First recorded activity by ExcelBanter: Oct 2006
Posts: 3
Default how to change from dollars to pounds in a balance sheet

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?





  #6   Report Post  
Old October 3rd 06, 04:40 PM posted to microsoft.public.excel.newusers
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 22,909
Default how to change from dollars to pounds in a balance sheet

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


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Links in Embedded doc within sheet don't change when sheet is copi Dan k Excel Discussion (Misc queries) 0 May 11th 06 05:41 PM
How to change decimal places in balance sheet template jdport Excel Worksheet Functions 1 May 10th 06 08:29 AM
macro to change data in inactive sheet Diana Excel Discussion (Misc queries) 1 April 28th 06 08:10 PM
How do I change the $ currency symbol in a balance sheet template Dave Excel Discussion (Misc queries) 1 November 20th 05 05:31 PM
Formulas not recalculating when values change on another sheet Bill Excel Worksheet Functions 0 September 15th 05 10:29 PM


All times are GMT +1. The time now is 08:57 AM.

Powered by vBulletin® Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.
Copyright 2004-2017 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017