|
4.656 bytes |
Service Hints & Tips |
Document ID: MCGN-3G2LM3 |
PS/1-Aptiva - Microsoft Works formatting column width for date or number to avoid #######
Applicable to: United States
If you enter a date or number in a Works for Windows spreadsheet or database, the column/field width should be set to a number greater than the maximum number of characters the cell or field will hold. The minimum size of this number is dependent on the width of the individual characters for the font used in the cell or database field.
It is usually sufficient to make the column/field width about 1.5 times larger than the maximum number of characters that will be in the cell or field. Proportional fonts such as Times New Roman and Arial will probably require a much smaller number. If the width for a date is not set wide enough, ######## will be displayed instead of the date. Also a True/False value will display as ###### if the column width is not wide enough to display the word
"True" or
"False."
WORKS 2.X SOLUTION:
To re-size a column width in Works for Windows version 2.x:
1. From the Format menu, choose column width.
2. Enter a value in the Width box (default is 10).
If you enter a number that is too large to fit into a cell that has general format, Works displays the number in scientific notation. An extra space must be added to maintain a placeholder for the sign (+/-) of the number. When a number is positive (greater than zero), the "+" that would represent it as a positive number is not displayed, but its placeholder must still be present.
Note: With proportionally spaced fonts such as Times New Roman or Arial you may be able to use a smaller column because character width will vary.
|
Search Keywords |
| |
|
Hint Category |
Productivity Software | |
|
Date Created |
11-04-97 | |
|
Last Updated |
24-03-99 | |
|
Revision Date |
24-03-2000 | |
|
Brand |
IBM Aptiva | |
|
Product Family |
Aptiva, PS/1 | |
|
Machine Type |
2011, 2121, 2123, 2133, 2155, 2168, 2144 | |
|
Model |
C01; C34; M01; NEA; T35; U35; A62; A82; A94; B82; C42; C92; G42; M82; S92; 081; 087; 131; 137; K37; N31; N81; 11E; 13T; 14C; 16E; 17A; 18A; 18T; 19C; 21C; 23C; 28A; 46M; 51D; D50; G11; G13; G43; G46; G46; G49; G49; G50; G53; M40; M40; M46; M46; P11; P13; P43; P50; P53; R04; R05; R06; R09; R38; R42; R43; R44; R84; R86; R87; RO3; S11; S13; S43; S45; S45; S47; S47; S48; S48; S50; S53; W11; W13; W42; W42; W43; W45; W45; W50; W53; 20E; 22T; 24C; 24M; 28V; 39E; 41T; 43C; 45V; 48E; 50T; 52C; 55V; 72E; 74T; 76C; 78C; 79C; 81A; 82E; 84T; 86C; 87C; CC1; D53; G14; G44; G52; G54; G72; G76; G78; G82; NM1; P14; P44; P57; P71; P74; P76; P78; P84; R14; R15; R16; R17; R18; R51; R52; R57; R58; R62; R63; R67; R71; R89; R93; R96; R97; S14; S44; S50; S54; S70; S75; S76; S78; S80; W14; W44; W48; W54; W67; W76; W77; W78; Z33; 28V; 31E; 33T; 37C; 38C; 51E; 54T; 56C; 57C; 88V; BB1; G57; G87; OR1; OR3; OR4; OR5; P89; R28; R29; R31; R74; R78; R82; R98; S55; S85; SR1; US1; W52; W82; 2R0; P30; 2R3; S15 | |
|
TypeModel |
| |
|
Retain Tip (if applicable) |
| |
|
Reverse Doclinks |