I assume you mean a number with a leading 0. Is this correct? Like a zip
code 06439? If so, you can format as text (or if it really is a zip code,
there is a built-in format for that, under Format/Special.) Or you could
format the cell with however many 0's you need. In the above case, 00000.

"Ella" wrote:

How do i tell excel to display zeros. I already went into
tools/options/view/zero values. That didn't work. What i am trying to
do is extract data from a text file,open it in excel(i would love to
have it open and work in access,but that is a different help group) and
have the colums with zeros in front of the data to show. But for some
reason it's not, anybody knows what i can do?
thanks