Formatting Headings in Word 2000!
If you are not using other headings in your document, you can use
the outline-numbered Heading styles even if you are not using them
all for *true* headings. Some documents—military documents are a
good example—have every paragraph numbered. This makes it easy
for them to referred to later. You can also bookmark them and
cross-reference them. Then, if an item's number changes because
you inserted another item, the cross-reference stays linked with
the correct paragraph.
To format for headings, follow the same instructions as above,
except that now you should choose a Heading style outline number
scheme. Edit to desired.
Warning: Some of these numbering schemes can get quite wide in the
amount of space they take up. For instance, an item numbered
10.12.22.4 that is followed by a half-inch indent can take up
quite a bit of the body width of your document. Your paragraph of
text is now indented considerably and an otherwise short paragraph
can take up a lot more page length. Using Outline numbering for
your heading styles is not recommended unless it meets
requirements of your company or firm, or if your document is
limited to perhaps Heading 3 or 4.
Converting Julian Dates in Excel 2000!
Since the 1950s, astronomers and geophysicists have used Julian
dates to track time in continuous, absolute terms, without
bothersome seasons, leap years, or man-made conventions. Julian
dates associate a date with the number of days elapsed since
January 1 of the same year. (For example, Jan. 2, 2000, has the
value of 2.)
Excel doesn't have a built-in option to convert dates to Julian
time, but you can use this shortcut to convert today's date to the
Julian format.
Just type this equation into any cell in your worksheet:
=VALUE(RIGHT(YEAR(TODAY()),2)&TEXT(TODAY()-DATE(YEAR(TODAY())-1,12,31),"000"))
Now, you'll need to format this value to display five digits.
1. Right-click the cell that contains the value and select Format
Cells.
2. On the Number tab, choose Custom from the Category list box.
3. In the Type text box, enter 00000.
Click OK.
Freeze columns in Access's Datasheet view (97-2000-2002)
|
Things to Note
Many Folks ask us how we cover so many topics. Most of our answers
come from a Database with 42 Topics and over 8000 entries. This
came from over 8 years of online help. Couple that with over 5000
documents on various subjects we have the ability to answer most
of your questions.
|