milly

Precede the number with an apostrophe or pre-format the cells as Text.


Gord Dibben MS Excel MVP

On Wed, 28 Jun 2006 05:57:01 -0700, milly8506
wrote:

I am trying to insert a lot of figures into a excel document,however when I
leave the cell, the zero at the beginning of the numbers always disappears,
how can I change this so it doesn't happen and the whole number stays in the
field?