Formatting Cells Contents

Introduction to Cells Numbers Formats

When it comes to displaying items, StarCalc uses some default formats, ranging from the font used by your application to the actual display of numbers in cells. The computer's Regional Settings govern how dates, numbers, and time, etc get displayed on your computer.
StarCalc recognizes numbers in various formats: accounting, scientific, fractions, and currency. As the software can recognize a number, you still have the ability to display the number with a format that suits a particular scenario.

Before finding out how to display numbers in different situations, you should be familiar with the way the application treats your numbers. That's why once again we will review some of the things we have already learned.

Practical Learning: Exploring Cells Number Formats

  1. Start StarCalc and open the Allentown Car Sales2 workbook
  2. Select cells G3:G10.
  3. In the Formatting toolbar, click the Number Format Currency button . The numbers in column G are now treated as price values and a $ sign has been appended to them.
  4. Select cells H3:H10. On the Formatting toolbar, click the Number Format Percent button . Now the numbers in column H are treated as percentage values
     
  5. Select cells G11:G17. We will now use the Format Cells dialog box.
  6. On the main menu, click Format -> Cells...
  7. On the Format Cells dialog box click the Numbers property sheet. In the Category list box, click Currency. In the Options section, make sure that the Decimal Places spin button displays 2
     
  8. Click OK. 
  9. Select cells H11:H17.
  10. Right-click in the selection and click Format Cells...
  11. click the Numbers tab if necessary. In the Category list box, click Percent.
  12. In the Options section, make sure the Decimal Places spin button is set to 2 and click OK.
  13. Select cells I9:I13.
  14. The dates can also be displayed in various formats. You can make your selection from the Format Cells dialog box in the Date category.
    On the main menu, click Format -> Cells...
  15. In the Category list, notice that the Date is already selected. In the type list, click Dec 31, 1999
     
  16. Click OK.
  17. To save the current workbook, on the Standard toolbar, click the Save button .


Special and Custom Formats

Although StarCalc can recognize number formats of various kinds, sometimes none of the preset formats will suit a particular need you have for a certain cell or group of cells. That's when you can use either one of the Special Formats or create your own.

If you get to using a worksheet that was prepared by someone else (or you) and find out that the format used by a cell or some cells is not appropriate, you can change it using the Cells Attributes dialog box.

Practical Learning: Select Cells Contents Using The Keyboard

  1. To start another workbook, Click the New button on the Function bar.
  2. In cell H1, type Age Structure
  3. In cell J1, type Life Expectancy At Birth
  4. In cell A2, type Country
  5. In cell B2, type Area
  6. In cell C2, type Population
  7. In cell D2, type Government
  8. In cell E2, type Independence
  9. In cell F2, type US Contact
  10. In cell G2, type Teens
  11. In cell H2, type Adults
  12. In cell I2, type Seniors
  13. In cell J2, type Total
  14. In cell K2, type Male
  15. In cell L2, type Female
  16. Save the workbook as World Stats
  17. Select columns B and C. Right-click on the selection and click Format Cells...
  18. In the Cells Attributes dialog box, click the Numbers property sheet. In the Category list, click Number. Set the Decimal Places to 0. Click the Thousands Separator (,) check box to check it
     
  19. Click OK.
  20. Double-click the line that separates the column headers between C and D
  21. Click column F to select the whole column
  22. Right-click the selection and click Format Cells...
  23. From the Numbers property sheet, in the Category list box, click User-Defined
  24. Click the empty box under Format Code and type (000) 000-0000
     
  25. Click OK.
  26. Double-click the line that separates the column headers between F and G
  27. Select columns G, H, and I. 
  28. Right-click in the selection and click Format Cells...
  29. From the Numbers property sheet, in the Category list, click Percent. Set the Decimal Places to 0 and click OK
     
  30. To save the workbook, press Ctrl + S.
  31. Open the GSC Employees1 workbook. Notice that the cells in column B have been to configured to display employees numbers with a period (.) after the first 2 number digits.
  32. Click column B to select the whole column.
    To clear a format that is set on some cells, click the selection and click Format Cells...
  33. In the Cells Attributes dialog box, in the Category list box of the Numbers tab, click Text and click OK. Now, the numbers display regularly.
  34. Click column H to select it. To use a special preset format, right-click in the selection and click Format Cells...
  35. From the Numbers property sheet, in the Category list, click All.
  36. Click the box under Format Code, delete its content, and type 000-000-0000
  37. Click OK.
  38. Double-click the line that separates the column headers between H and I
  39. To use a custom format, we will change the way dates in column G display. Instead of 04/14/89, we prefer 14-April-89.
    Click column G to select it. Right the selection and click Format Cells...
  40. In the Category list, click User-Defined. In the empty text box under Format Code and type
    d mmmm yyyy
  41. Click OK.
  42. Double-click the line separator between G and H. Notice how dates display now.
  43. Click column B to select it
  44. Now we will configure how employees numbers display. Instead of 38002, we will display 38-002. To achieve that, we will create our own format.
    To create a custom format, right-click in the selection and click Format Cells... 
  45. In the Category list, click User-Defined.
  46. In the empty box under Format Code, type 0#-##0
  47. Click OK. Notice how the employees numbers display now
     
  48. Save the workbook.

 

Checking the Computer's Regional Settings

Many settings that control how your computer displays dates, time, and other numbers are configured in the system Registry and controlled by the computer itself. This makes sure that your computer is in tune with the language you use in your computer experience and certainly keeps you synchronized with your computer neighbors.

The computer's Regional Settings can be viewed and/or changed from the Control Panel by double-clicking the Regional Settings icon.

  1. From the Taskbar, click Start -> Settings -> Control Panel.
  2. In Control Panel, double-click Regional Settings.
  3. Click the Regional Settings property sheet. Check the language that your computer is using.
  4. Click the Number property sheet. Examine how the numbers are configured for your computer.
  5. Click the Currency property sheet. Check how the money value is set to display in your computer.
  6. Click the Date property sheet. Check how dates are set to display in your computer.
  7. Click the Time property sheet. Review how the numbers are set to display in your computer.
  8. When you have finished examining the property sheets, click Cancel (unless you want to save or apply the changes you might have made, in which case you would click OK).

 

Text and Cells Formatting: AutoFormat

A good worksheet is not simply determined by its functionality, its look plays a great deal and reflects your tastes in fonts, styles, and design. Before we experiment with its design capabilities, we will first find out how StarCalc can help with choosing fonts, font styles, sizes, and colors.

Cell formatting allows you to control how text displays in your cells, how much room various columns and rows need in order to display their content. StarCalc ships with sample table with each configured to suit a specific scenario. Whenever possible, or you are simply in a hurry, use one of these readily available samples; one of the sample AutoFormat tables can make your table or part of your worksheet look professional.

To use the AutoFormat, first select the cells you want to format; then on the main menu, click Format -> AutoFormat... From the AutoFormat dialog box, select the style you want and click OK. You can change your style any time and many times until you are satisfied.

  1. Start a new workbook.
  2. In Sheet1, click cell B5 and type Robert
  3. Click cell C4 and type January
  4. Complete the worksheet as follows:
     
       January February March April May June
    Robert 2600 3450 2860 3840 3250 3480
    Lucy 3580 3420 3550 2860 3640 3520
    Annette 460 1240 1850 2380 2650 2870
    Josiane 840 650 520 720 550 480
    Salif 620 580 610 560 820 520
     
  5. To save the workbook, press Ctrl + S. Save it as Alexandria Furniture1
  6. Select cells B4:H9.
  7. On the main menu, click Format -> AutoFormat...
  8. From the AutoFormat dialog box, click Brown
     
  9. Click OK.
  10. Press Ctrl + Home see the result.
  11. On the main menu, click Edit -> Undo AutoFormat.
  12. Cells B4:H9 should be selected; otherwise, select them. On the main menu again, click Format -> AutoFormat...
  13. From the AutoFormat dialog box, click Currency 3D.
  14. Click the More >> button
  15. Click the Font check box to remove its check mark.
  16. Also click the AutoFit Width And Height check box to remove its check mark:
     
  17. Click OK.
  18. On the main menu, click Tools -> Options...
  19. From the Options dialog box, under Spreadsheet, click View
  20. In the Visual Aids section, click the check box of Grid Lines to clear it.
  21. Click OK
  22. Save the workbook and close StarCalc.

 


Previous Home Next

Copyright © 2002 FunctionX

 

World Stats

              Age Structure Life Expectancy At Birth
Country Area Population Government Independence US Contact Teens Adults Seniors Total Male Female
Algeria 2381740 31133486 Republic 05 July 1962 2022652800 0.37 0.59 0.04 69.24 68.07 70.46
Netherlands 41532 15807641 Monarchy 1579 2022445300 0.18 0.68 0.14 78.15 75.28 81.17
Venezuela 912050 23203466 Republic 5 July 1801 2023422214 0.33 0.62 0.05 72.95 69.97 76.16
Australia 7686850 18783551 Democratic 01 January 1901 2027973000 0.21 0.66 0.13 80.14 77.22 83.23
Yemen 527970 16942230 Republic 22 May 1990 2029654760 0.48 0.49 0.03 59.98 58.17 61.88
Swaziland 17360 985335 Monarchy 06 September 1968 2023626683 0.46 0.51 0.03 38.11 36.86 39.4