Page 68 - Ms Excel Note and Workbook
P. 68

MICROSOFT EXCEL NOTE AND WORKBOOK

























               You can also select the desired cells and press Ctrl+1 on your keyboard to access more number-

               formatting options.


               In this example, we've applied the Currency number format, which adds currency symbols ($) and
               displays two decimal places for any numerical values.

























               If you select any cells with number formatting, you can see the actual value of the cell in the formula
               bar. The spreadsheet will use this value for formulas and other calculations.




                                                                                        TIP

                                                                                If you don't need to use a
                                                                                specific number format,
                                                                                the spreadsheet will
                                                                                usually apply the general
                                                                                number format by default

               Using number formats correctly:






                                                                                               59 | P a g e
   63   64   65   66   67   68   69   70   71   72   73