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

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.

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.

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.

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.

See this old post:

http://tinyurl.com/399byu

--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"C Tate" wrote in message
...
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.

Someone else will have to explain how to enter Alt + 0163 on a laptop.

Have never used one.


Gord

On Sat, 29 Mar 2008 11:19:00 -0700, C Tate
wrote:

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.

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.

"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.

Just add some zeros.

£0",000,000"


Gord

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

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.

"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.