LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #8   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 2,345
Default Formatting currency query

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


Replace @mailinator.com with @tiscali.co.uk


"Gord Dibben" <gorddibbATshawDOTca wrote in message
...
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.








 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
query about CURRENCY BOX?? Deonne O'Donnell New Users to Excel 6 October 1st 06 07:18 PM
conditional formatting for currency TC Excel Worksheet Functions 1 May 20th 06 01:55 PM
Currency Formatting chalky Excel Discussion (Misc queries) 1 January 18th 06 01:51 PM
Currency Formatting. John Smith Excel Discussion (Misc queries) 3 November 1st 05 02:21 PM
Currency Formatting Janbri Excel Discussion (Misc queries) 2 July 3rd 05 03:58 PM


All times are GMT +1. The time now is 09:12 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"