{"id":4573,"date":"2008-09-07T07:20:23","date_gmt":"2008-09-07T12:20:23","guid":{"rendered":"http:\/\/magic1host.com\/blog\/2008\/09\/07\/excel-2007-number-currency-and-accounting\/"},"modified":"2008-09-07T07:20:23","modified_gmt":"2008-09-07T12:20:23","slug":"excel-2007-number-currency-and-accounting","status":"publish","type":"post","link":"https:\/\/magic1host.com\/blog\/?p=4573","title":{"rendered":"Excel 2007 Number, Currency And Accounting"},"content":{"rendered":"
by Lynne Kramer<\/div>\n

When entering numbers into a spreadsheet, you sometimes need to ensure that the number format is consistent. For example, if the numbers in question represent prices, you may want to display a currency symbol or you may simply want to make sure that the number of decimals displayed is consistent..<\/p>\n

Unless you specify otherwise, all numbers in Excel are rendered in the “General” format. This means that numbers are displayed exactly as you enter them: if you enter two decimals, two decimals are displayed; if you went to one decimal, one decimal is displayed; and so on.<\/p>\n

To specify the number format, the best idea is usually to select the entire column. To do this, simply click on the letter or letters representing the column. (If text is contained in the selection, it will not be affected by the number format you specify.)<\/p>\n

Number formats are specified in the “Numbers” group of the Home Tab of Excel’s Ribbon. There are three important formats which apply to numbers: the first is simply called “Number”, the second “Currency” and the third “Accounting”. To gain access to the complete range of number formats, click on “More Number Formats” in the “Numbers” drop-down menu. Another way of opening the “Numbers” dialog box is to click on the launch button in the “Numbers” group of the Home Tab of the Excel Ribbon.<\/p>\n

When you click on one of the number formats on the left of the “Numbers” dialogue box, you are given a series of choices which enable you to refine the way that the format will work. Thus, if your numbers refer to an hourly rate, you would click the “Number” category in the left column and then specify two decimal places. The option to “Use Thousands Separator” will add the appropriate separator to demarcate thousands. The separator used will depend on your locality: for example, in the UK or USA, a comma will be used; in European countries, a dot will be used.<\/p>\n

The final option in the “Number” category lets you control the display of negative numbers. The default is to preced the number with a minus sign and to leave the colour of the text unchanged. However, you can also suppress the minus sign and change the colour of negative numbers to red; or, if you prefer, you can change the colour of negative numbers to red as well as displaying the minus sign.<\/p>\n

Clicking the “Currency” category, reveals pretty much the same choices as “Number” with the addition of a currency symbol. You can specify which currency symbol is used or you can dispense with the currency symbol altogether.<\/p>\n

The “Accounting” category is pretty much the same as “Currency”. Once again, you can choose a particular currency symbol. However, you will notice that you do not have any choices relating<\/a> to negative numbers. The convention in accountancy circles is to always place negative numbers in brackets.<\/p>\n

As well as using the number dialog box, you’ll notice a series of handy buttons which can apply each of the number formats with one click. There are also a couple of buttons for increasing and decreasing the number of decimals displayed in the selected cells.<\/p>\n

Finally, there may be times where you enter a number into a cell but do not want Excel to treat it as a number. For example, if you have a column of data representing an ID, although the ID may be numeric, you may not want Excel to regard it as a number or to modify it in any way. You will probably want it to simply stay exactly as it was entered. Whenever that’s the case, it’s best to format the number as “Text”. The simplest way of doing this is to highlight the appropriate column and in the number dialog box choose “Text” as the category.<\/p>\n

\n
About the Author:<\/div>\n
The author is a trainer and developer with TrainingCompany.Com<\/a>, a UK IT training company offering Microsoft Excel Classes<\/a> at their central London training centre.<\/div>\n<\/div>\n","protected":false},"excerpt":{"rendered":"

When entering numbers into a spreadsheet, you sometimes need to ensure that the number format is consistent. For example, if the numbers in question represent prices, you may want to display a currency symbol or you may simply want to make sure that the number of decimals displayed is consistent..<\/p>\n","protected":false},"author":239,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[23],"tags":[96],"class_list":["post-4573","post","type-post","status-publish","format-standard","hentry","category-training","tag-training"],"_links":{"self":[{"href":"https:\/\/magic1host.com\/blog\/index.php?rest_route=\/wp\/v2\/posts\/4573","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/magic1host.com\/blog\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/magic1host.com\/blog\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/magic1host.com\/blog\/index.php?rest_route=\/wp\/v2\/users\/239"}],"replies":[{"embeddable":true,"href":"https:\/\/magic1host.com\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=4573"}],"version-history":[{"count":0,"href":"https:\/\/magic1host.com\/blog\/index.php?rest_route=\/wp\/v2\/posts\/4573\/revisions"}],"wp:attachment":[{"href":"https:\/\/magic1host.com\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=4573"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/magic1host.com\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=4573"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/magic1host.com\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=4573"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}