#### in Worksheet Cell

Problem

A cell shows #### (pound signs) in any MacNail construction software worksheet

Diagnosis

nearly always: column width is too small

Solution

widen the column (may be necessary to unprotect document to access col width cmd). If it shows a number then, explain how Excel displays things.
If it shows #VALUE or other error, track it down. (see Excel Number Value Error)
OR the cell contains a date that is greater than the maximum date allowed on the Mac (year 2040).

Comments

Entered 10/10/92 by Dennis. Updated 11/13/2010.