 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / New Users / March 2008Formatting currency query
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 >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! > Custom Format of £0",000" > [quoted text clipped - 8 lines] > >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 >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 [quoted text clipped - 12 lines] >> >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! > In the Custom dialog box hold the Alt key down then type 0163 on the NumPad on > rightside of keyboard. [quoted text clipped - 21 lines] > >> >How can I quickly change the basic figures to represent the currencies as > >> >above? Thanks. See this old post: http://tinyurl.com/399byu  SignatureHTH, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- > Brilliant. Only one problem - I don't have a number pad! I use a laptop! > [quoted text clipped - 23 lines] > > >> >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 >Brilliant. Only one problem - I don't have a number pad! I use a laptop! > [quoted text clipped - 23 lines] >> >> >How can I quickly change the basic figures to represent the currencies as >> >> >above? Thanks. 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. SignatureHTH Sandy In Perth, the ancient capital of Scotland and the crowning place of kings sandymann2@mailinator.com Replace @mailinator.com with @tiscali.co.uk > Someone else will have to explain how to enter Alt + 0163 on a laptop. > [quoted text clipped - 47 lines] >>> >> >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. > Custom Format of £0",000" > [quoted text clipped - 8 lines] > >How can I quickly change the basic figures to represent the currencies as > >above? Thanks. 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? [quoted text clipped - 12 lines] >> >How can I quickly change the basic figures to represent the currencies as >> >above? Thanks.
|
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.