Problem: I have a series of closing stock prices. If the price for the day goes up, I want to display an up symbol. If the price goes down, display a down symbol.
Excel for Office 365 for Mac Excel 2019 for Mac Excel 2016 for Mac Excel for Mac 2011 More. Less If your sheet contains zero values or contains calculations that produce zero values, you can hide the values or use formatting options to change how the values will display. How to Change from Lowercase to Uppercase in Excel. Microsoft's Excel spreadsheet program has several functions to make your text type-case consistent. It is a blue epsilon symbol and looks like the letter “E.” The formula bar (fx) will be highlighted so that you can type in your function. How do I delete a number from 1-50 without.
Strategy: Use an IF statement in combination with a Webdings or Wingdings font.
Most computers have at least four font faces composed of symbols. To easily browse the symbols, enter =CHAR(ROW()) in cells A1:A256. Change the font for column A to Webdings or one of the three Wingdings fonts. As you browse through the symbols and see one that you would like, click on the symbol. Below is a possible arrow to use. You can see that this is in the Wingdings 3 font. From the row number, you know it is character code 199. From the formula bar, you can see that it is the C with a cedilla mark below.
Character 199 is a possibility.
If you are reading this and you have a Portuguese keyboard, you probably have a key with the cedilla C. However, you will have to fly to France to find an E with a grave accent. You could try to master the art of holding down Alt while typing 0199 on the numeric keypad, or you could use CHAR(199).
Personally, for me, all of those are too much hassle and I won't use the arrows shown above. Instead, I found the symbols that correspond to letters on my keyboard, so that I can easily type them in the formula.
These six symbols are all typeable on a U.S. keyboard.
The strategy is to write an IF statement that produces a 5 for positive and a 6 for negative. Then, format those cells to use the Webdings font.
Use a formula such as =IF(B2>B3,5,6) to use the Webdings symbols. If you prefer the filled triangles from Wingdings 3, use =IF(B2>B3,'p','q'). Initially, you will get a column of 5 and 6.
The formula produces 5's and 6's.
Select column C and change the font to Webdings. Use Left alignment.
Convert the column to Wingdings.
Gotcha: If you ever need to edit the formula in C, it will appear in Webdings font and be unreadable in the cell. Use the Formula bar to see the real formula.
If you want to display the arrows in green and red, change the font color of column C to green. Then use Home, Conditional Formatting, Highlight Cells Rules, Equal to, 5. Open the Format dropdown and choose Custom Format. On the Font tab, choose a bright red.
If you have Excel 2010, you can use the new Up, Flat, Down icon set. See Icon Sets in Part IV of this book.
Alternate Strategy: You can avoid the IF statement and use a custom number format. Use a formula of =SIGN(B2-B3) in column C. This will return a negative one for days that the price went down, positive one for days when the price went up, and a zero for days where the price is unchanged.
Change the custom number format to [green]r;[red]s;. Change the font to Wingdings 3.
Forcing Excel to show r for positive and s for negative.
The custom number format is using three zones. The first zone is showing a lower case r in green for any positive number. The second zone is showing a lower case s in red for any negative number. The third zone is indicated by the final semi-colon and is blank, indicating no symbol for zero values. When you convert column C to Wingdings 3, you get the arrows shown.
For more resources for Microsoft Excel
Related Articles
1 Change the Character Set in Excel 2007
2 Add Shading in PowerPoint 2003
3 Double Underline in Excel on Mac
4 Open XLS Files in Mac OS X
Microsoft Office for Mac is a suite of applications that includes Word for creating text documents and Excel for making spreadsheets. If you don’t want to use the default font in Office each time you create a new document, you can designate the font of your choice by changing the preferences settings. You have to quit Excel and Word and restart the applications before the new default font settings will take effect for future documents that you create.
Word
1.
Launch Microsoft Word and open a new blank document.
2.
Click “Font” on the Format menu and then click the “Font” tab.
3.
Click the Font pull-down menu and select the name of the font you want to set as the new default.
5.
Quit Word and then relaunch the application. New documents that you create will use the font you selected.
Excel
1.
Launch Microsoft Excel on your Mac and open a new blank document.
2.
Click the “Excel” menu and then click “Preferences.”
3.
Select the 'General' preferences in the Authoring section. Click the “Standard Font” drop-down menu and click the name of the font you want to set for the default. Click 'OK.'
4.
Quit Excel and then relaunch the application. New spreadsheets that you create will now use the default font you selected.
Warning
Information in this article applies to Microsoft Office version 2011 running on Macs with the OS X 10.8 operating system. It may vary slightly or significantly with other versions or products.
References (2)
Resources (1)
About the Author
Julius Vandersteen has been a freelance writer since 1999. His work has appeared in “The Los Angeles Times,” “Wired” and “S.F. Weekly.” Vandersteen has a Bachelor of Arts in journalism from San Francisco State University.
Photo Credits
David Paul Morris/Getty Images News/Getty Images
Cite this Article
Choose Citation Style
Vandersteen, Julius. 'How to Change the Default Font on Microsoft Office for a Mac.' Small Business - Chron.com, http://smallbusiness.chron.com/change-default-font-microsoft-office-mac-63818.html. Accessed 15 December 2019.
Vandersteen, Julius. (n.d.). How to Change the Default Font on Microsoft Office for a Mac. Small Business - Chron.com. Retrieved from http://smallbusiness.chron.com/change-default-font-microsoft-office-mac-63818.html
Vandersteen, Julius. 'How to Change the Default Font on Microsoft Office for a Mac' accessed December 15, 2019. http://smallbusiness.chron.com/change-default-font-microsoft-office-mac-63818.html
Note: Depending on which text editor you're pasting into, you might have to add the italics to the site name.