Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
i want to change dollar sign to rands on excel invoice? | Excel Discussion (Misc queries) | |||
changing currency from Dollar to Pounds Sterling | Excel Discussion (Misc queries) | |||
Changing Dollar sign to another currency not listed in Excel | Excel Discussion (Misc queries) | |||
Change Currency symbol dependant upon selected cell value | Excel Discussion (Misc queries) | |||
why does currency format change to number format? | Excel Discussion (Misc queries) |