and other formatting problems
To force a column of data to text, select it, as shown below. Press Ctrl-1 or pick Format Cells from the menu. The dialog box shown will appear. Pick the Number tab on the dialog box, and select the Text format option in the list of formats.
Other formatting problems which can arise are due to leading or trailing spaces in a field. These may not be visually obvious, but can prevent a species code or stratum code being recognized
Obscure mistakes, such as typing 2O.3, instead of 20.3 ('O' instead of zero) can cause data reading problems that are hard to locate.
MYRLIN detects the end of lists (plot data, species lists, stratum list, etc.) by looking for an empty cell. If the cell in fact contains one or more spaces, the program may try to continue and give an error message. To ensure cells are truly empty at the end of a list, select them and press the Del(Delete) key .