On Tue, 20 Nov 2007 08:45:02 -0800, Jaxboo
wrote:

Excel keeps taking any digit over 11 and displays them as zero's, Is there
anyway to prevent this? I have tried custom formats to no avail.

Here you write, "over 11"; in another post you write "over 12"

Is it, perhaps, over 15? If so, then you will need to enter the number as TEXT
by either formatting the cell as TEXT BEFORE entering the value, or by
preceding the entry with a single quote.
--ron