alansmythe
Technical User
Could anyone advise, please, how to make a tick mark in this software.
Appreciate anyones assistance.
Alan Smythe
Appreciate anyones assistance.
Alan Smythe
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Lotus 123 version 5.1 - Tick Mark
- Thread starter alansmythe
- Start date
- Status
DaleWatson123321
Programmer
Alan,
It would have helped if you had defined what you mean by a "tick mark".
CLARIFICATION...
I will assume you are referring to the following character... ' This character is the one located on the same key which has the following character... " This key is located two keys to the right of the "L".
BACKGROUND...
The tick character (the ') is used by Lotus 123 as what is called a "label prefix", more exactly a "left-aligned label prefix". This means it is used by Lotus to align characters (numbers and letters) on the LEFT side of the cell.
By default, whenever you enter a letter, Lotus 123 automatically places the left-aligned label prefix ( ' ) into the cell - and it shows to the LEFT of the letter(s) you enter. To notice the character, you will have to look at the "EDIT" line - at the top of the screen.
SOLUTION TO YOUR QUESTION...
To "make a tick mark", you only need to type TWO tick marks. The FIRST one will not show in the cell, but the SECOND tick mark will show.
EXAMPLE FOR USING A LEFT-ALIGNED LABEL PREFIX...
If you want to enter an address (for example, 456 Main Street), Lotus will NOT allow you to make such an entry UNLESS you FIRST type the LABEL PREFIX ( ' ).
The reason for Lotus 123 having a problem with the "456 Main Street" is because, WITHOUT having typed a label-prefix, Lotus 123 notices that you have started with a NUMBER (456) and therefore Lotus 123 automatically treats your entry as a NUMBER entry. However, because you then follow the NUMBER with LETTERS (Main Street), Lotus 123 prevents you from entering such an entry because a VALID "NUMBER" entry CANNOT be MIXED with "LETTERS" ...UNLESS you FIRST use the LABEL-PREFIX.
There are a total of THREE label-prefixs. The other two are the double quote ( " ) - which also tells Lotus 123 to accept the entry as "TEXT" (not a number) and to align the text on the RIGHT side of the cell.
The other label-prefix is the "hat chararacter" ( ^ ) - the one above the "6". This causes the entry to be CENTERED in the cell.
All three of these LABEL-PREFIXs can be entered MANUALLY by typing the characters. However, an alternate method of aligning data already entered into a cell is by using the icons - located to the right of the "U" icon (for underlining).
I hope this helps. Please advise.
Regards, ...Dale Watson dwatson@bsi.gov.mb.ca
or nd.watson@shaw.ca
It would have helped if you had defined what you mean by a "tick mark".
CLARIFICATION...
I will assume you are referring to the following character... ' This character is the one located on the same key which has the following character... " This key is located two keys to the right of the "L".
BACKGROUND...
The tick character (the ') is used by Lotus 123 as what is called a "label prefix", more exactly a "left-aligned label prefix". This means it is used by Lotus to align characters (numbers and letters) on the LEFT side of the cell.
By default, whenever you enter a letter, Lotus 123 automatically places the left-aligned label prefix ( ' ) into the cell - and it shows to the LEFT of the letter(s) you enter. To notice the character, you will have to look at the "EDIT" line - at the top of the screen.
SOLUTION TO YOUR QUESTION...
To "make a tick mark", you only need to type TWO tick marks. The FIRST one will not show in the cell, but the SECOND tick mark will show.
EXAMPLE FOR USING A LEFT-ALIGNED LABEL PREFIX...
If you want to enter an address (for example, 456 Main Street), Lotus will NOT allow you to make such an entry UNLESS you FIRST type the LABEL PREFIX ( ' ).
The reason for Lotus 123 having a problem with the "456 Main Street" is because, WITHOUT having typed a label-prefix, Lotus 123 notices that you have started with a NUMBER (456) and therefore Lotus 123 automatically treats your entry as a NUMBER entry. However, because you then follow the NUMBER with LETTERS (Main Street), Lotus 123 prevents you from entering such an entry because a VALID "NUMBER" entry CANNOT be MIXED with "LETTERS" ...UNLESS you FIRST use the LABEL-PREFIX.
There are a total of THREE label-prefixs. The other two are the double quote ( " ) - which also tells Lotus 123 to accept the entry as "TEXT" (not a number) and to align the text on the RIGHT side of the cell.
The other label-prefix is the "hat chararacter" ( ^ ) - the one above the "6". This causes the entry to be CENTERED in the cell.
All three of these LABEL-PREFIXs can be entered MANUALLY by typing the characters. However, an alternate method of aligning data already entered into a cell is by using the icons - located to the right of the "U" icon (for underlining).
I hope this helps. Please advise.
Regards, ...Dale Watson dwatson@bsi.gov.mb.ca
or nd.watson@shaw.ca
- Thread starter
- #3
alansmythe
Technical User
I am really sorry. By tick mark I mean a mark a teacher places next to a correct piece of work! If it was wrong it would be a "X" if it was correct it would be a "tick" for correct.
Sorry in the UK we call them ticks!
Sorry in the UK we call them ticks!
DaleWatson123321
Programmer
Alan,
Thanks for the clarification. I should have asked for the clarification FIRST. However...
The answer you are looking for is simply related to the use of a DIFFERENT FONT - one which includes the "Tick Mark" and the (stylized) "X". Incidentally, the term we use in Canada (and I believe also in the U.S.) is "Check Mark".
There are TWO fonts that I know of which include the Tick/Check Mark and the "X". There are probably others. These fonts are "Wingdings" and "ZapfDingbats BT".
My preference is "ZapfDingbats BT" - because the style of Tick/Check Mark and "X" looks better. With this font, once you have formatted the cells where you intend to use the Tick Mark or "X", you then simply enter one of these numbers: 3,4,5,6,7 or 8.
With "Wingdings"... After formatting the cells, you need to HOLD DOWN the "ALT" key while typing one of these numbers: 0251, 0252, 0253, or 0254, and then hit <Enter>. Also, the "x" (lower case) will produce a stylized "X" with a box around it.
I hope this is the answer you were looking for.
Regards, ...Dale Watson dwatson@bsi.gov.mb.ca
or nd.watson@shaw.ca
Thanks for the clarification. I should have asked for the clarification FIRST. However...
The answer you are looking for is simply related to the use of a DIFFERENT FONT - one which includes the "Tick Mark" and the (stylized) "X". Incidentally, the term we use in Canada (and I believe also in the U.S.) is "Check Mark".
There are TWO fonts that I know of which include the Tick/Check Mark and the "X". There are probably others. These fonts are "Wingdings" and "ZapfDingbats BT".
My preference is "ZapfDingbats BT" - because the style of Tick/Check Mark and "X" looks better. With this font, once you have formatted the cells where you intend to use the Tick Mark or "X", you then simply enter one of these numbers: 3,4,5,6,7 or 8.
With "Wingdings"... After formatting the cells, you need to HOLD DOWN the "ALT" key while typing one of these numbers: 0251, 0252, 0253, or 0254, and then hit <Enter>. Also, the "x" (lower case) will produce a stylized "X" with a box around it.
I hope this is the answer you were looking for.
Regards, ...Dale Watson dwatson@bsi.gov.mb.ca
or nd.watson@shaw.ca
- Status
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question