Re-install Office and update us with the results. We have just done that, but it appears that Excel continues to ignore the change. In the Type input box, add a comma after the format syntax. After the Format Cells dialog box opens, click the Custom option to get to the screen shown in this figure.
#Excel for mac, format thousands mac os x#
In Mac OS X International system preferences. To show your numbers in thousands, highlight them, right-click, and select Format Cells. Specify a different system separator by changing the regional settings
Note: Excel uses the Mac OS system separator for thousands. On the Home tab, under Number, click Display the value of a cell with a thousands separator. Select the cells that you want to adjust. Note: Excel uses the Mac OS system separator for thousands. From the Excel Help window: Display or hide the thousands separator. Number, click Display the value of a cell with a thousands separator. For example in the data displayed below the thousand separator is a full-stop and the decimal separator is a comma.
#Excel for mac, format thousands how to#
You can change this setting so cells formatted as numbers display the same number of decimal places. In this video I demonstrate how to convert European formatted numbers to UK format. By default, cells formatted as numbers display as many decimal places as you type in them. Click the Data Format pop-up menu in the sidebar, then choose Automatic. Type in ,0.0, K to display 1,500,800 as 1,500.8 K. In the Format sidebar, click the Cell tab. Go to the Number tab (it is the default tab if you haven’t opened before). Select the cells that you want to adjust. Press Ctrl+1 or right click and choose Format Cells to open the Format Cells dialog.
Also note that cells that appear to be above about 30 are shown in bold and in green. Instead, set the Region to United States (without the Computer part).įrom the Excel Help window: Display or hide the thousands separator So 27 and at 26 are highlighted with this format or rather the formats been applied. This appears to be the result, as you stated, of an OS X update. The DOLLAR function is a built-in function in Excel that is categorized as a String/Text Function.It can be used as a worksheet function (WS) in Excel. Looking below shows that this region formats numbers without a thousands separator. The Microsoft Excel DOLLAR function converts a number to text, using a currency format. If the first region dropdown menu is United States (Computer), this might be your problem. Go into System Preferences > Language and Text and click the "Region" tab. A temporary workaround is always simply Command- A to select all cells and clicking this convenient button in the ribbon under the Home tab in the Number section:
0 kommentar(er)
