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.