Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Imraan Rawat
 
Posts: n/a
Default How do i change the currency from dollar to GB pounds

I am using office excel 2003, I have created a invoice and I need to change
the currency from dollar to GB pounds.


  #2   Report Post  
Max
 
Posts: n/a
Default

Not sure .. but guess you could try this ..

Select the col (or the range)

Click Format Cells Currency
Scroll down the options under "Symbol"
and select the option which appears as:
" £ English (United Kingdom) "

(that's what I can do in xl97 over here)
--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----
"Imraan Rawat" <Imraan wrote in message
...
I am using office excel 2003, I have created a invoice and I need to

change
the currency from dollar to GB pounds.




  #3   Report Post  
RagDyer
 
Posts: n/a
Default

Select the cell(s) concerned and then:

<Format <Cells <Number tab,
And click on "Currency" in the left window.
Expand the "Symbol" box, and scroll down to find the country and symbol that
you need.
--
HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================



"Imraan Rawat" <Imraan wrote in message
...
I am using office excel 2003, I have created a invoice and I need to

change
the currency from dollar to GB pounds.



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
i want to change dollar sign to rands on excel invoice? sylvia Excel Discussion (Misc queries) 4 July 19th 05 11:14 AM
changing currency from Dollar to Pounds Sterling Lee Excel Discussion (Misc queries) 1 May 18th 05 02:16 PM
Changing Dollar sign to another currency not listed in Excel Rehan Excel Discussion (Misc queries) 1 April 12th 05 04:03 PM
Change Currency symbol dependant upon selected cell value Fred Excel Discussion (Misc queries) 3 March 23rd 05 11:57 AM
why does currency format change to number format? Cassie Excel Discussion (Misc queries) 3 March 18th 05 06:57 PM


All times are GMT +1. The time now is 09:52 PM.

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

About Us

"It's about Microsoft Excel"