Quattro Pro Tutorial

Entering Data and Formatting Cells

Entering numeric or text data is almost as easy as typing it. By almost, I mean that in most cases all you have to do is type the data but there are a few cases where you have to be aware of how Quattro Pro will handle and display the data. Entering Avogadro’s number, 6.023x1023, for example, is done a little differently than when typing it in a document. Entering dates and times also has special features. Quattro Pro also offers a number of ways to display the data – date and time formats, currency formats, and custom formats such as displaying the number 1,048,576, equal to 1024 x 1024, one meg in computer terms, as 1.0 M.

The exercises in this tutorial cover entering numeric and text data and formatting the data to make it look nice. After completing these exercises you should be able to enter any type of data and format it according to the data type and your personal preferences.

Contents


Entering Numbers

Normal numbers...

Complex numbers...

Scientific notation...

Formatting numbers...

Replace this figure.
Back to top

Entering Text

Entering text....

Entering and justifying text at the same time...

Entering numbers as text...

Entering formulas as text...

Formatting text...

Replace this figure.

 

Text Formatting Shortcuts

Quattro Pro's text formatting shortcuts are nearly identical to those used by most word processors. The shortcuts below will format the text displayed in a cell, whether of not the contents are numeric or string.

CTRL+I Italics
CTRL+B Bold
CTRL+U Underline
CTRT+L Left-justify
CTRL+E Center
CTRL+R Right-justify
Back to top

Entering Currency

Entering currency...

Doing this formats the cell to display numbers as currency...

Formatting currency...

Illustration

Back to top

Entering Dates

Dates are stored internally as integers where it represents the number of days since December 30, 1889. The number 30,000, for example, which is 30,000 days since Dec 30, 1899, is February 18, 1982.  So, one option for entering dates is to enter just such an integer.

The other, easier option, is to enter the date using a conventional date format. In the U.S. this format is usually "mm/dd/yyyy", where mm is the month, dd the day and yyyy the year. Actually, you can also enter it as m/d/yy or similar variations and and Quattro Pro will take care of it and will display it as a date using the short date format, i.e. 02/18/1982. However, if you enter a date that does not exist, such as 1/40/2, Quattro Pro will perform division instead of parsing it as a date.

Formatting dates...

Illustration

Back to top

Entering Times

The time of day is stored internally as a fraction representing the fraction of time in a 24-hour day.  For example, noon is represented by the number 0.5, and midnight by either the number 0.0 or 1.0.  So like dates, one option for entering the time of day is to enter just a number, in this case a fractional number.

The other, easier option, is to enter the time using a conventional time format. In the most countries this format is usually "hh:mm:ss", where hh is the hour in either a 12 or 24-hour day, mm the minutes in the hour, and ss the seconds. Actually, you can also enter the time as h:m, h:m:s, or similar variations, and Quattro Pro will take care of it and will display it as a time using the short time format, i.e. 1:25:19.  One thing to note that if you specify an hour less than 13 (12-hour day format) then Quattro Pro will assume you mean this is a morning time. To tell Quattro Pro that it is actually an afternoon time simply include "PM" (not case sensitive) in your time entry. But if you enter a time that does not exist, such as 14:89:02, or even a partial time entry like 8:, Quattro Pro will assume the entry is text and will display exactly what you typed.

Formatting time...

Illustration

Back to top

Custom Formatting

Illustration

Back to top

Hints and Suggestions

  • There may be more to the number you see displayed in a cell. Formatting may truncate the number, for instance displaying π as 3.1416 when we all know the number of digits of π is well over 2 billion digits. Your calculations may not require 2 billion digits precision, but 5 digits may be too little. Keep this in mind when entering data such as physical constants. By the way, Quattro Pro’s @PI function returns the number 3.14159265358979, 15 digits.

  • How does one enter a number such as one-third? Either type 0.3333... using as many 3's as you thing you need, or enter the formula =1/3. Obviously the latter option is easier and will yield the maximum resolution.
Back to top