Brilliant. Only one problem - I don't have a number pad! I use a laptop!

"Gord Dibben" wrote:

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

On Sat, 29 Mar 2008 10:25:00 -0700, C Tate
wrote:

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!

"Gord Dibben" wrote:

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

On Sat, 29 Mar 2008 09:37:00 -0700, C Tate
wrote:

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.