Works: Values in Formatted Fields Treated as Text (141655)
The information in this article applies to:
- Microsoft Works 6
- Microsoft Works 2000
- Microsoft Works 4.5
- Microsoft Works for Windows 95, version 4.0
This article was previously published under Q141655 SUMMARY
In a Works 4.0 or later Database, a time or date entered in a field that has not been formatted for a time or date will be treated as text.
For example, a date entered into a field formatted as a number is treated as text.
This does not apply to a field formatted as General. General-formatted
fields take on the formatting of the first value entered into them. For
example, if the first entry in a General-formatted field is a date, the
field will be formatted as a date.
MORE INFORMATION
This does not apply to the Spreadsheet. For example, if you enter a
date into a cell that has been formatted as Time, the cell will be
reformatted to a Date format. Previous versions of Works for Windows
used this reformatting in both the Spreadsheet and Database.
To determine if Works is treating a value as text, check if
there is a quotation mark (") preceding the value in the formula bar. Text
entries will have the quotation mark; numeric values will not. Text entries
also have a left alignment, whereas numeric values are right aligned by
default.
| Modification Type: | Major | Last Reviewed: | 11/15/2004 |
|---|
| Keywords: | kbinfo KB141655 |
|---|
|