In some cases you may want to display a number with leading zeros (i.e. 007). ClarisWorks Spreadsheet and ClarisImpact Table Model will normally identify 007 as a number and trim the leading zeros. To override this, type an equal sign and enclose the number in double quotes.
Example: ="007"
In the above example, 007 will be displayed WITH the leading zeros and will default to left justification as all text fields do.