Weird Number Formats

Problem

Numbers in cells appear strangely formatted: e.g. typing in "122" will show up as 1.22.

Diagnosis

If it just happens in certain cells, it is probably a number format problem. Choose Format\Number and change the format to something reasonable.
if it happens everywhere, check in Options\Workspace.... there is a checkbox for "Fixed Decimal Places". If it is checked, that's the problem. Unchecking it will restore the number formatting.

This is an XL "feature" which can really cause confusion for the occasional user of MacNail construction software!

Solution

KuWindows to David K. for the fix!

Comments

Entered 12/22/92 by Vinay. Updated 11/13/2010.