Formatting currency query

  • Thread starter Thread starter C Tate
  • Start date Start date
C

C Tate

At the moment my spreadsheet has figures in such as 303 and 528. These
numbers represent thousands. So 303 means £303,000 and 528 means £528,000.
How can I quickly change the basic figures to represent the currencies as
above? Thanks.
 
Custom Format of £0",000"

Use Alt + 0163 to enter the £ sign.

Note: value will not change, just the format.


Gord Dibben MS Excel MVP
 
Thanks. I have managed to get the 303 to display as 303,000 but I cannot
enter the pound sign. Can you explain how to do this? When I hit alt then try
to type a number the pc just pings!
 
In fact, some of my figures are now in the millions so it would be useful if
there was a million pound separator too. How would I go about adding that?
Your advice is v much appreciated.
 
In the Custom dialog box hold the Alt key down then type 0163 on the NumPad on
rightside of keyboard.

NumLock on, of course.

Do not use the number keys above the qwerty keys.


Gord
 
Just add some zeros.

£0",000,000"


Gord

In fact, some of my figures are now in the millions so it would be useful if
there was a million pound separator too. How would I go about adding that?
Your advice is v much appreciated.
Click to expand...
 
Someone else will have to explain how to enter Alt + 0163 on a laptop.

Have never used one.


Gord
 
On my Samsung laptop, there is a key labelled "Fn" and the function key F9
also has "Num Lock" in green. There are15 or the letter/symbol keys have
the numbers/symbols of the key pad. Pressing "Fn" + "Num Lock" caused the
15 keys to act like the number pad.

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings

(e-mail address removed)
Replace @mailinator.com with @tiscali.co.uk
 
Back
Top